{"id":1850,"date":"2023-10-31T15:55:47","date_gmt":"2023-10-31T15:55:47","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/"},"modified":"2023-12-06T05:51:43","modified_gmt":"2023-12-06T05:51:43","slug":"nieuwe-lijn","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/","title":{"rendered":"Hoe voeg ik een nieuwe regel toe in vba-code?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-2127536814\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>In VBA zijn er drie verschillende (constanten) voor het toevoegen van een regeleinde.<\/p><ol><li> vbNieuweLijn<\/li><li> vbCrLf<\/li><li> vbLf<\/li><\/ol><h2 class=\"wp-block-heading\"> vbNieuweLijn<\/h2><p> vbNewLine voegt een nieuweregelteken in dat in een nieuweregel wordt geplaatst. In de onderstaande coderegel heb je twee tekenreeksen die hiermee worden gecombineerd.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\") = \"Line1\" &amp; vbNewLine &amp; \"Line2\"<\/code><\/pre><p> Wanneer u <a href=\"https:\/\/exceladvisor.org\/nl\/voer-een-macro-uit-2\/\">deze macro uitvoert<\/a> , wordt de tekenreeks in twee regels geretourneerd. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51775\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-nouvelle-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-nieuwe regel\" width=\"644\" height=\"281\"><\/figure><\/div><p> Het retourneert de tekens 13 en 10 (Chr(13) + Chr(10)). U kunt code ook op de volgende manier gebruiken om hetzelfde resultaat te bereiken.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\") = \"Line1\" &amp; Chr(13) &amp; Chr(10) &amp; \"Line2\"<\/code><\/pre><p> Maar als u vbNewLine gebruikt, hoeft u de CHAR-functie niet te gebruiken.<\/p><h2 class=\"wp-block-heading\"> vbCrLf<\/h2><p> De constante vbCrLf staat voor Carriage Return en Line Feed, wat betekent dat Cr de cursor naar het begin van de regel verplaatst en Lf de cursor naar de volgende regel verplaatst.<\/p><p> Wanneer u vbCrLf in twee tekenreeksen of waarden gebruikt, zoals in de volgende code, wordt er een nieuwe regel ingevoegd. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\") = \"Line1\" &amp; vbCrLf &amp; \"Line2\"<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51776\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-retour-chariot-et-saut-de-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"regelretour en regelinvoer\" width=\"655\" height=\"294\"><\/figure><\/div><h2 class=\"wp-block-heading\"> vbLf<\/h2><p> De vbLf-constante staat voor newline-teken, en wanneer u deze in twee strings gebruikt, retourneert deze een newline-teken dat een nieuwe regel toevoegt voor de tweede string. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\") = \"Line1\" &amp; vbLf &amp; \"Line2\"<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51777\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-vblf-qui-ajoutent-une-nouvelle-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"vblf-die-een-nieuwe-regel toevoegt\" width=\"659\" height=\"307\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Voeg een nieuwe regel toe in VBA MsgBox<\/h2><p> Als u een nieuwe regel wilt toevoegen wanneer u <a href=\"https:\/\/exceladvisor.org\/nl\/vba-berichtbox\/\">VBA MsgBox gebruikt,<\/a> kunt u een van de drie bovenstaande constanten gebruiken die we hebben besproken.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">MsgBox \"Line1\" &amp; vbNewLine &amp; \"Line2\" MsgBox \"Line1\" &amp; vbCrLf &amp; \"Line2\" MsgBox \"Line1\" &amp; vbLf &amp; \"Line2\"<\/code><\/pre><p> Er is ook een vbCr-constante die een regelterugloopteken retourneert dat u kunt gebruiken om een nieuwe regel in een berichtvenster in te voegen.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">MsgBox \"Line1\" &amp; vbCr &amp; \"Line2\"<\/code><\/pre><p> vbCr werkt niet als u <a href=\"https:\/\/exceladvisor.org\/nl\/cel-waarde\/\">een celwaarde wilt invoeren<\/a> totdat u er <a href=\"https:\/\/exceladvisor.org\/nl\/omlooptekst-1\/\">teruglooptekst op toepast<\/a> .<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/nl\/vba\/\">Wat is VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Gerelateerde tutorials <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/interview-vragen\/\">VBA-interviewvragen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/opmerking\/\">Voeg een opmerking toe in VBA-code<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/regeleinde\/\">Voeg een regeleinde toe in VBA-code<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/voer-een-macro-uit-2\/\">Voer een macro uit in Excel (Voer VBA-code uit)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/onmiddellijke-vensterfoutopsporing-afdrukken\/\">VBA onmiddellijk venster (Debug.Print)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/module\/\">VBA-module<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/vba-berichtbox\/\">VBA-berichtbox<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/voorwerpen\/\">VBA-objecten<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1850","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Hoe voeg ik een nieuwe regel toe in VBA-code?<\/title>\n<meta name=\"description\" content=\"Deze tutorial behandelt verschillende manieren om een nieuwe regel toe te voegen (carriage return) die u kunt gebruiken terwijl u meerdere regels combineert\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe voeg ik een nieuwe regel toe in VBA-code?\" \/>\n<meta property=\"og:description\" content=\"Deze tutorial behandelt verschillende manieren om een nieuwe regel toe te voegen (carriage return) die u kunt gebruiken terwijl u meerdere regels combineert\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:51:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-nouvelle-ligne.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/\",\"name\":\"\u25b7 Hoe voeg ik een nieuwe regel toe in VBA-code?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-nouvelle-ligne.png\",\"datePublished\":\"2023-10-31T15:55:47+00:00\",\"dateModified\":\"2023-12-06T05:51:43+00:00\",\"description\":\"Deze tutorial behandelt verschillende manieren om een nieuwe regel toe te voegen (carriage return) die u kunt gebruiken terwijl u meerdere regels combineert\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-nouvelle-ligne.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-nouvelle-ligne.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe voeg ik een nieuwe regel toe in vba-code?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Hoe voeg ik een nieuwe regel toe in VBA-code?","description":"Deze tutorial behandelt verschillende manieren om een nieuwe regel toe te voegen (carriage return) die u kunt gebruiken terwijl u meerdere regels combineert","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe voeg ik een nieuwe regel toe in VBA-code?","og_description":"Deze tutorial behandelt verschillende manieren om een nieuwe regel toe te voegen (carriage return) die u kunt gebruiken terwijl u meerdere regels combineert","og_url":"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:51:43+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-nouvelle-ligne.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/","url":"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/","name":"\u25b7 Hoe voeg ik een nieuwe regel toe in VBA-code?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-nouvelle-ligne.png","datePublished":"2023-10-31T15:55:47+00:00","dateModified":"2023-12-06T05:51:43+00:00","description":"Deze tutorial behandelt verschillende manieren om een nieuwe regel toe te voegen (carriage return) die u kunt gebruiken terwijl u meerdere regels combineert","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-nouvelle-ligne.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-nouvelle-ligne.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/nieuwe-lijn\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe voeg ik een nieuwe regel toe in vba-code?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1850","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1850"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1850\/revisions"}],"predecessor-version":[{"id":2856,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1850\/revisions\/2856"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}