{"id":375,"date":"2023-10-31T16:00:11","date_gmt":"2023-10-31T16:00:11","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/salto-de-linea\/"},"modified":"2023-12-25T10:23:03","modified_gmt":"2023-12-25T10:23:03","slug":"salto-de-linea","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/salto-de-linea\/","title":{"rendered":"\u00bfc\u00f3mo agregar un salto de l\u00ednea en el c\u00f3digo vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1965080303\"><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>Al escribir c\u00f3digos VBA, es posible que se enfrente a una situaci\u00f3n en la que tenga una larga l\u00ednea de c\u00f3digo, lo que dificulta su lectura para todos. En este caso, la mejor manera es utilizar el <strong>car\u00e1cter de salto de l\u00ednea de VBA<\/strong> , que tiene en el siguiente ejemplo. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51730\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-caractere-de-saut-de-ligne-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"car\u00e1cter de nueva l\u00ednea vba\" width=\"695\" height=\"298\"><\/figure>\n<\/div>\n<p> En la primera macro solo tienes una l\u00ednea larga, pero en la segunda macro esa misma l\u00ednea se divide en tres l\u00edneas con caracteres de continuaci\u00f3n de l\u00ednea.<\/p>\n<p> Ahora, si miras de cerca, las dos primeras l\u00edneas tienen un gui\u00f3n bajo al final.<\/p>\n<p> Si deseas dividir una l\u00ednea en dos o m\u00e1s, debes <strong>escribir un espacio seguido de un gui\u00f3n bajo<\/strong> . <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51731\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-un-trait-de-soulignement.png\" sizes=\"auto, \" srcset=\"\" alt=\"usar un gui\u00f3n bajo\" width=\"414\" height=\"91\"><\/figure>\n<\/div>\n<p> Uno de los beneficios m\u00e1s importantes de utilizar un salto de l\u00ednea es la creaci\u00f3n de c\u00f3digo estructurado y f\u00e1cil de leer.<\/p>\n<h2 class=\"wp-block-heading\"> Salto de l\u00ednea en c\u00f3digo VBA<\/h2>\n<p> Para ingresar un salto de l\u00ednea VBA, puede seguir los siguientes pasos.<\/p>\n<ol type=\"1\">\n<li> Primero, haz clic en el personaje del que deseas cortar la l\u00ednea.<\/li>\n<li> <strong>Luego escriba un espacio<\/strong> ( ).<\/li>\n<li> Despu\u00e9s de eso, <strong>escriba un gui\u00f3n bajo<\/strong> (_).<\/li>\n<li> Al final, <strong>presione Enter<\/strong> para cortar la l\u00ednea.<\/li>\n<\/ol>\n<p> Pero hay una cosa de la que debes ocuparte; no puedes agregar una nueva l\u00ednea en medio del argumento. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51732\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-etapes-de-saut-de-ligne-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"pasos de salto de l\u00ednea vba\" width=\"334\" height=\"109\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Varias l\u00edneas de c\u00f3digo en una sola l\u00ednea<\/h2>\n<p> VBA tambi\u00e9n te permite escribir varias l\u00edneas de c\u00f3digo en la misma l\u00ednea. Supongamos que desea combinar dos l\u00edneas de c\u00f3digo en una sola l\u00ednea. Puede utilizar dos puntos (:) para esto. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51733\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-lignes-de-code-multiples.png\" sizes=\"auto, \" srcset=\"\" alt=\"varias l\u00edneas de c\u00f3digo\" width=\"372\" height=\"189\"><\/figure>\n<\/div>\n<p> Entonces ser\u00e1: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51734\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-utiliser-un-colon.png\" sizes=\"auto, \" srcset=\"\" alt=\"usar dos puntos\" width=\"440\" height=\"149\"><\/figure>\n<\/div>\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\/nueva-linea\/\">Agregue una nueva l\u00ednea (retorno de carro) en una cadena en 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<li> <a href=\"https:\/\/exceladvisor.org\/es\/cuaderno-macro-personal\/\">Libro de macros personal (personal.xlsb)<\/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\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Al escribir c\u00f3digos VBA, es posible que se enfrente a una situaci\u00f3n en la que tenga una larga l\u00ednea de c\u00f3digo, lo que dificulta su lectura para todos. En este caso, la mejor manera es utilizar el car\u00e1cter de salto de l\u00ednea de VBA , que tiene en el siguiente ejemplo. En la primera macro [&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-375","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 un salto de 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\/salto-de-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 un salto de l\u00ednea en el c\u00f3digo vba?\" \/>\n<meta property=\"og:description\" content=\"Al escribir c\u00f3digos VBA, es posible que se enfrente a una situaci\u00f3n en la que tenga una larga l\u00ednea de c\u00f3digo, lo que dificulta su lectura para todos. En este caso, la mejor manera es utilizar el car\u00e1cter de salto de l\u00ednea de VBA , que tiene en el siguiente ejemplo. En la primera macro [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/salto-de-linea\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:23:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-caractere-de-saut-de-ligne-vba.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\/salto-de-linea\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/salto-de-linea\/\",\"name\":\"\u00bfc\u00f3mo agregar un salto de l\u00ednea en el c\u00f3digo vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/salto-de-linea\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/salto-de-linea\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-caractere-de-saut-de-ligne-vba.png\",\"datePublished\":\"2023-10-31T16:00:11+00:00\",\"dateModified\":\"2023-12-25T10:23:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/salto-de-linea\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/salto-de-linea\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/salto-de-linea\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-caractere-de-saut-de-ligne-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-caractere-de-saut-de-ligne-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/salto-de-linea\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo agregar un salto de 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 un salto de 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\/salto-de-linea\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo agregar un salto de l\u00ednea en el c\u00f3digo vba?","og_description":"Al escribir c\u00f3digos VBA, es posible que se enfrente a una situaci\u00f3n en la que tenga una larga l\u00ednea de c\u00f3digo, lo que dificulta su lectura para todos. En este caso, la mejor manera es utilizar el car\u00e1cter de salto de l\u00ednea de VBA , que tiene en el siguiente ejemplo. En la primera macro [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/salto-de-linea\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:23:03+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-caractere-de-saut-de-ligne-vba.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\/salto-de-linea\/","url":"https:\/\/exceladvisor.org\/es\/salto-de-linea\/","name":"\u00bfc\u00f3mo agregar un salto de l\u00ednea en el c\u00f3digo vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/salto-de-linea\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/salto-de-linea\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-caractere-de-saut-de-ligne-vba.png","datePublished":"2023-10-31T16:00:11+00:00","dateModified":"2023-12-25T10:23:03+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/salto-de-linea\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/salto-de-linea\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/salto-de-linea\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-caractere-de-saut-de-ligne-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-caractere-de-saut-de-ligne-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/salto-de-linea\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo agregar un salto de 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\/375","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=375"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/375\/revisions"}],"predecessor-version":[{"id":813,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/375\/revisions\/813"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}