{"id":376,"date":"2023-10-31T15:55:47","date_gmt":"2023-10-31T15:55:47","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/nueva-linea\/"},"modified":"2023-12-25T10:23:13","modified_gmt":"2023-12-25T10:23:13","slug":"nueva-linea","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/nueva-linea\/","title":{"rendered":"\u00bfc\u00f3mo agregar una nueva l\u00ednea en el c\u00f3digo vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2748279523\"><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>En VBA hay tres (constantes) diferentes para agregar un salto de l\u00ednea.<\/p>\n<ol>\n<li> vbNuevaL\u00ednea<\/li>\n<li> vbCrLf<\/li>\n<li> vbLf<\/li>\n<\/ol>\n<h2 class=\"wp-block-heading\"> vbNuevaL\u00ednea<\/h2>\n<p> vbNewLine inserta un car\u00e1cter de nueva l\u00ednea que va dentro de una nueva l\u00ednea. En la l\u00ednea de c\u00f3digo siguiente tiene dos cadenas combinadas usando esto.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\") = \"Line1\" &amp; vbNewLine &amp; \"Line2\"<\/code><\/pre>\n<p> Cuando <a href=\"https:\/\/exceladvisor.org\/es\/ejecutar-una-macro-2\/\">ejecuta esta macro<\/a> , devuelve la cadena en dos l\u00edneas. <\/p>\n<div class=\"wp-block-image\">\n<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-nueva-linea\" width=\"644\" height=\"281\"><\/figure>\n<\/div>\n<p> Devuelve los caracteres 13 y 10 (Chr(13) + Chr(10)). Tambi\u00e9n puede utilizar el c\u00f3digo de la siguiente manera para lograr el mismo resultado.<\/p>\n<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>\n<p> Pero cuando usas vbNewLine no necesitas usar la funci\u00f3n CHAR.<\/p>\n<h2 class=\"wp-block-heading\"> vbCrLf<\/h2>\n<p> La constante vbCrLf significa retorno de carro y avance de l\u00ednea, lo que significa que Cr mueve el cursor al inicio de la l\u00ednea y Lf mueve el cursor a la siguiente l\u00ednea.<\/p>\n<p> Cuando usa vbCrLf en dos cadenas o valores, como en el siguiente c\u00f3digo, inserta una nueva l\u00ednea. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\") = \"Line1\" &amp; vbCrLf &amp; \"Line2\"<\/code><\/pre>\n<div class=\"wp-block-image\">\n<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=\"retorno de carro y avance de l\u00ednea\" width=\"655\" height=\"294\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> vbLf<\/h2>\n<p> La constante vbLf significa car\u00e1cter de nueva l\u00ednea y cuando la usa en dos cadenas, devuelve un car\u00e1cter de nueva l\u00ednea que agrega una nueva l\u00ednea para la segunda cadena. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\") = \"Line1\" &amp; vbLf &amp; \"Line2\"<\/code><\/pre>\n<div class=\"wp-block-image\">\n<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-que-agrega-una-nueva-l\u00ednea\" width=\"659\" height=\"307\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Agregar nueva l\u00ednea en VBA MsgBox<\/h2>\n<p> Si desea agregar una nueva l\u00ednea cuando usa <a href=\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensajes-vba\/\">VBA MsgBox,<\/a> puede usar cualquiera de las tres constantes anteriores que hemos discutido.<\/p>\n<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>\n<p> Tambi\u00e9n hay una constante vbCr que devuelve un car\u00e1cter de retorno de carro que puede utilizar para insertar una nueva l\u00ednea en un cuadro de mensaje.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">MsgBox \"Line1\" &amp; vbCr &amp; \"Line2\"<\/code><\/pre>\n<p> vbCr no funcionar\u00e1 si desea <a href=\"https:\/\/exceladvisor.org\/es\/valor-de-celda\/\">ingresar un valor de celda<\/a> hasta que le <a href=\"https:\/\/exceladvisor.org\/es\/ajustar-texto-1\/\">aplique texto envolvente<\/a> .<\/p>\n<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\/es\/vba\/\">\u00bfQu\u00e9 es VBA?<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/preguntas-de-entrevista\/\">Preguntas de entrevista para VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/comentario\/\">A\u00f1adir un comentario en c\u00f3digo VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/salto-de-linea\/\">Agregue un salto de l\u00ednea en el c\u00f3digo VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ejecutar-una-macro-2\/\">Ejecute una macro en Excel (Ejecute c\u00f3digo VBA)<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-50067b57\">\n<div class=\"gb-container gb-container-50067b57\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/impresion-de-depuracion-inmediata-de-ventana\/\">Ventana inmediata de VBA (Debug.Print)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/modulo\/\">m\u00f3dulo VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensajes-vba\/\">Cuadro de mensajes VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/objetos\/\">Objetos VBA<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En VBA hay tres (constantes) diferentes para agregar un salto de l\u00ednea. vbNuevaL\u00ednea vbCrLf vbLf vbNuevaL\u00ednea vbNewLine inserta un car\u00e1cter de nueva l\u00ednea que va dentro de una nueva l\u00ednea. En la l\u00ednea de c\u00f3digo siguiente tiene dos cadenas combinadas usando esto. Range(\u00abA1\u00bb) = \u00abLine1\u00bb &amp; vbNewLine &amp; \u00abLine2\u00bb Cuando ejecuta esta macro , devuelve [&hellip;]<\/p>\n","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-376","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>\u00bfc\u00f3mo agregar una nueva l\u00ednea en el c\u00f3digo vba?<\/title>\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\/es\/nueva-linea\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo agregar una nueva l\u00ednea en el c\u00f3digo vba?\" \/>\n<meta property=\"og:description\" content=\"En VBA hay tres (constantes) diferentes para agregar un salto de l\u00ednea. vbNuevaL\u00ednea vbCrLf vbLf vbNuevaL\u00ednea vbNewLine inserta un car\u00e1cter de nueva l\u00ednea que va dentro de una nueva l\u00ednea. En la l\u00ednea de c\u00f3digo siguiente tiene dos cadenas combinadas usando esto. Range(&quot;A1&quot;) = &quot;Line1&quot; &amp; vbNewLine &amp; &quot;Line2&quot; Cuando ejecuta esta macro , devuelve [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/nueva-linea\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:23:13+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=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/nueva-linea\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/nueva-linea\/\",\"name\":\"\u00bfc\u00f3mo agregar una nueva l\u00ednea en el c\u00f3digo vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/nueva-linea\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/nueva-linea\/#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-25T10:23:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/nueva-linea\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/nueva-linea\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/nueva-linea\/#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\/es\/nueva-linea\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo agregar una nueva l\u00ednea en el c\u00f3digo vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo agregar una nueva l\u00ednea en el c\u00f3digo vba?","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\/es\/nueva-linea\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo agregar una nueva l\u00ednea en el c\u00f3digo vba?","og_description":"En VBA hay tres (constantes) diferentes para agregar un salto de l\u00ednea. vbNuevaL\u00ednea vbCrLf vbLf vbNuevaL\u00ednea vbNewLine inserta un car\u00e1cter de nueva l\u00ednea que va dentro de una nueva l\u00ednea. En la l\u00ednea de c\u00f3digo siguiente tiene dos cadenas combinadas usando esto. Range(\"A1\") = \"Line1\" &amp; vbNewLine &amp; \"Line2\" Cuando ejecuta esta macro , devuelve [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/nueva-linea\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:23:13+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":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/nueva-linea\/","url":"https:\/\/exceladvisor.org\/es\/nueva-linea\/","name":"\u00bfc\u00f3mo agregar una nueva l\u00ednea en el c\u00f3digo vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/nueva-linea\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/nueva-linea\/#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-25T10:23:13+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/nueva-linea\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/nueva-linea\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/nueva-linea\/#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\/es\/nueva-linea\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo agregar una nueva l\u00ednea en el c\u00f3digo vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/376","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=376"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/376\/revisions"}],"predecessor-version":[{"id":826,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/376\/revisions\/826"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}