{"id":664,"date":"2023-09-29T02:30:39","date_gmt":"2023-09-29T02:30:39","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/salida-bajo\/"},"modified":"2023-12-25T10:31:52","modified_gmt":"2023-12-25T10:31:52","slug":"salida-bajo","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/salida-bajo\/","title":{"rendered":"\u00bfc\u00f3mo utilizar vba exit sub en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1203722071\"><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>VBA Exit Sub es una declaraci\u00f3n que se utiliza para salir de un subprocedimiento o funci\u00f3n. Como sabe, cada l\u00ednea es una macro que se ejecuta una tras otra, y cuando agrega el VBA \u00abExit Sub\u00bb, salga del procedimiento sin ejecutar el resto del c\u00f3digo que viene despu\u00e9s. Esto funciona mejor con <a href=\"https:\/\/exceladvisor.org\/es\/bucles\/\">bucles<\/a> y el <a href=\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensajes-vba\/\">cuadro de mensaje<\/a> .<\/p>\n<h2 class=\"wp-block-heading\"> Usando la subsentencia de salida en VBA<\/h2>\n<ol type=\"1\">\n<li> Primero, decida en qu\u00e9 l\u00ednea desea agregar el \u00abSub de salida\u00bb.<\/li>\n<li> Despu\u00e9s de eso, verifique la estructura del c\u00f3digo que se ejecutar\u00e1 cuando <a href=\"https:\/\/exceladvisor.org\/es\/ejecutar-una-macro-2\/\">ejecute el c\u00f3digo<\/a> .<\/li>\n<li> A continuaci\u00f3n, ingrese \u00abSalir Sub\u00bb.<\/li>\n<li> En \u00faltima instancia, es mejor tener <a href=\"https:\/\/exceladvisor.org\/es\/comentario\/\">un comentario<\/a> que describa por qu\u00e9 est\u00e1 utilizando la declaraci\u00f3n \u00abSalir de Sub\u00bb. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55808\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"subsentencia de salida de vba\" width=\"683\" height=\"373\"><\/figure>\n<\/div>\n<p class=\"qt-tip\"> <strong>Nota:<\/strong> En un <a href=\"https:\/\/exceladvisor.org\/es\/funcion-definida-por-el-usuario-2\/\">procedimiento de funci\u00f3n<\/a> de VBA, la declaraci\u00f3n que debe utilizar es \u00abSalir de funci\u00f3n\u00bb.<\/p>\n<h2 class=\"wp-block-heading\"> Utilice Exit Sub con un cuadro de mensaje y un cuadro de entrada<\/h2>\n<p> Suponga que desea obtener informaci\u00f3n del usuario con un cuadro de entrada y salir del procedimiento si la respuesta del usuario no es un n\u00famero (considere 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-55809\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-sorties-sub-avec-une-boite-de-message.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"686\" height=\"312\"><\/figure>\n<\/div>\n<p> En el c\u00f3digo anterior tiene <a href=\"https:\/\/exceladvisor.org\/es\/isnumerico\/\">ISNUMERIC<\/a> que verifica el valor ingresado en el cuadro de entrada si es un n\u00famero o no, y si ese valor no es un n\u00famero, usa la instrucci\u00f3n de salida Sub para completar el procedimiento despu\u00e9s de mostrar un cuadro de mensaje.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_exit_sub_example() If IsNumeric(InputBox(\"Enter your age.\", \"Age\")) = False Then MsgBox \"Error! Enter your Age in numbers only.\" Exit Sub Else MsgBox \"Thanks for the input.\" End If End Sub<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> En caso de error Salir Sub<\/h2>\n<p> Una de las mejores cosas de \u00abSalir Sub\u00bb es que puedes usarlo para salir del procedimiento cuando ocurre un error. A continuaci\u00f3n se muestra el c\u00f3digo que divide un n\u00famero por cero, lo que devuelve un \u00abError de tiempo de ejecuci\u00f3n &#8217;11\u2032\u00bb y detiene la ejecuci\u00f3n. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55810\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-sur-erreur-sortie-sous.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"491\" height=\"334\"><\/figure>\n<\/div>\n<p> Aqu\u00ed puede utilizar la instrucci\u00f3n GoTo para crear un controlador de errores con \u00abExit Sub\u00bb para salir del procedimiento (considere el siguiente c\u00f3digo). <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55811\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-utiliser-linstruction-goto.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"520\" height=\"381\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_exit_sub_on_error() On Error GoTo iError Range(\"A1\") = 10 \/ 0 iError: MsgBox \"You can't divide with the zero.\" &amp; _ \"Change the code.\" Exit Sub End Sub<\/code><\/pre>\n<p> En el c\u00f3digo anterior tiene un controlador de errores, \u00abiError\u00bb con un cuadro de mensaje, luego la declaraci\u00f3n \u00abSalir de Sub\u00bb. Cuando se produce un error durante el c\u00e1lculo, la instrucci\u00f3n goto pasa al controlador de errores ( <a href=\"https:\/\/exceladvisor.org\/es\/manejo-de-errores\/\">VBA Error Handling<\/a> ) y sale del procedimiento.<\/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\/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<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>VBA Exit Sub es una declaraci\u00f3n que se utiliza para salir de un subprocedimiento o funci\u00f3n. Como sabe, cada l\u00ednea es una macro que se ejecuta una tras otra, y cuando agrega el VBA \u00abExit Sub\u00bb, salga del procedimiento sin ejecutar el resto del c\u00f3digo que viene despu\u00e9s. Esto funciona mejor con bucles y el [&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-664","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 utilizar vba exit sub en excel?<\/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\/salida-bajo\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo utilizar vba exit sub en excel?\" \/>\n<meta property=\"og:description\" content=\"VBA Exit Sub es una declaraci\u00f3n que se utiliza para salir de un subprocedimiento o funci\u00f3n. Como sabe, cada l\u00ednea es una macro que se ejecuta una tras otra, y cuando agrega el VBA \u00abExit Sub\u00bb, salga del procedimiento sin ejecutar el resto del c\u00f3digo que viene despu\u00e9s. Esto funciona mejor con bucles y el [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/salida-bajo\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:31:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-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\/salida-bajo\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/salida-bajo\/\",\"name\":\"\u00bfc\u00f3mo utilizar vba exit sub en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/salida-bajo\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/salida-bajo\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-vba.png\",\"datePublished\":\"2023-09-29T02:30:39+00:00\",\"dateModified\":\"2023-12-25T10:31:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/salida-bajo\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/salida-bajo\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/salida-bajo\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/salida-bajo\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar vba exit sub en excel?\"}]},{\"@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 utilizar vba exit sub en excel?","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\/salida-bajo\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar vba exit sub en excel?","og_description":"VBA Exit Sub es una declaraci\u00f3n que se utiliza para salir de un subprocedimiento o funci\u00f3n. Como sabe, cada l\u00ednea es una macro que se ejecuta una tras otra, y cuando agrega el VBA \u00abExit Sub\u00bb, salga del procedimiento sin ejecutar el resto del c\u00f3digo que viene despu\u00e9s. Esto funciona mejor con bucles y el [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/salida-bajo\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:31:52+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-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\/salida-bajo\/","url":"https:\/\/exceladvisor.org\/es\/salida-bajo\/","name":"\u00bfc\u00f3mo utilizar vba exit sub en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/salida-bajo\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/salida-bajo\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-vba.png","datePublished":"2023-09-29T02:30:39+00:00","dateModified":"2023-12-25T10:31:52+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/salida-bajo\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/salida-bajo\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/salida-bajo\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/salida-bajo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar vba exit sub en excel?"}]},{"@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\/664","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=664"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/664\/revisions"}],"predecessor-version":[{"id":1386,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/664\/revisions\/1386"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}