{"id":717,"date":"2023-09-25T15:00:15","date_gmt":"2023-09-25T15:00:15","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/bucles\/"},"modified":"2023-12-25T10:32:34","modified_gmt":"2023-12-25T10:32:34","slug":"bucles","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/bucles\/","title":{"rendered":"Bucles vba: la gu\u00eda definitiva para principiantes"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1593791510\"><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 class=\"wp-block-heading\"><strong>Puntos importantes<\/strong><\/p>\n<ol>\n<li> El uso de bucles en VBA puede resultar \u00fatil cuando desea realizar una tarea repetitiva.<\/li>\n<li> Tambi\u00e9n puedes usar un bucle dentro de otro bucle (anidamiento).<\/li>\n<li> Aseg\u00farate de tener cuidado al crear un bucle infinito.<\/li>\n<\/ol>\n<h2 class=\"wp-block-heading\"> \u00bfQu\u00e9 es un BUCLE en VBA?<\/h2>\n<p> En VBA, un LOOP es una estructura que puede repetir una instrucci\u00f3n. En pocas palabras, un bucle puede realizar una o m\u00e1s actividades y volver al principio para comenzar de nuevo una determinada cantidad de veces o hasta que se cumpla una condici\u00f3n. Este ciclo de ejecuci\u00f3n de un bucle se llama iteraci\u00f3n. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52033\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.png\" sizes=\"auto, \" srcset=\"\" alt=\"estructura-bucle-vba1\" width=\"499\" height=\"299\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Tipos de LOOP en VBA<\/h2>\n<p> En VBA, hay seis tipos diferentes de bucles que puedes usar, pero tambi\u00e9n puedes describirlos en dos categor\u00edas b\u00e1sicas.<\/p>\n<ol>\n<li> <strong>Para el siguiente<\/strong> : Para usar FOR NEXT LOOP, debe establecer un n\u00famero como contador para la cantidad de veces que se ejecuta el bucle. Si desea realizar un bucle 10 veces, debe establecer este valor para el contador. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"vba-para-siguiente-bucle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-pour-la-boucle-suivante.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-for-next-loop\" width=\"521\" height=\"107\"><\/li>\n<li> <strong>Para cada uno<\/strong> : con PARA CADA uno, puede explorar todos los objetos de una colecci\u00f3n de objetos. Como cada colecci\u00f3n tiene una cantidad determinada de objetos, esto la convierte en un bucle fijo.<\/li>\n<li> <strong>Do While Loop<\/strong> : prueba una condici\u00f3n y luego contin\u00faa realizando la actividad siempre que esa condici\u00f3n sea VERDADERA. En t\u00e9rminos simples, primero prueba una condici\u00f3n y solo ejecuta la declaraci\u00f3n si se cumple esa condici\u00f3n.<\/li>\n<li> <strong>Hacer bucle mientras<\/strong> : funciona igual que &#8216;Hacer mientras&#8217; pero primero itera la actividad y luego prueba la condici\u00f3n y, si esa condici\u00f3n es VERDADERA, contin\u00faa realizando esa actividad.<\/li>\n<li> <strong>Do Until Loop<\/strong> : prueba una condici\u00f3n y luego contin\u00faa ejecutando la declaraci\u00f3n que definiste hasta que esa condici\u00f3n sea FALSA y en el momento en que esa condici\u00f3n se vuelva VERDADERA, se detiene. B\u00e1sicamente, es lo opuesto a \u00abHacer mientras\u00bb.<\/li>\n<li> <strong>Bucle hasta<\/strong> : funciona igual que \u00abHacer hasta\u00bb, pero primero itera la actividad y luego prueba la condici\u00f3n y, si esa condici\u00f3n es FALSA, contin\u00faa realizando esta actividad.<\/li>\n<\/ol>\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\/seleccione-el-caso\/\">Caso de selecci\u00f3n de VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/hacer-mientras\/\">Excel VBA Do While Loop y (Do Loop While): una gu\u00eda<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/hojas-de-bucle\/\">Recorra todas las hojas usando VBA en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/recorrer-el-rango\/\">Recorre un rango usando VBA (Columnas, Filas y Rango Usado)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/para-el-bucle\/\">VBA FOR LOOP (para el siguiente, para cada uno)<\/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>Puntos importantes El uso de bucles en VBA puede resultar \u00fatil cuando desea realizar una tarea repetitiva. Tambi\u00e9n puedes usar un bucle dentro de otro bucle (anidamiento). Aseg\u00farate de tener cuidado al crear un bucle infinito. \u00bfQu\u00e9 es un BUCLE en VBA? En VBA, un LOOP es una estructura que puede repetir una instrucci\u00f3n. En [&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-717","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>Bucles vba: la gu\u00eda definitiva para principiantes<\/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\/bucles\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bucles vba: la gu\u00eda definitiva para principiantes\" \/>\n<meta property=\"og:description\" content=\"Puntos importantes El uso de bucles en VBA puede resultar \u00fatil cuando desea realizar una tarea repetitiva. Tambi\u00e9n puedes usar un bucle dentro de otro bucle (anidamiento). Aseg\u00farate de tener cuidado al crear un bucle infinito. \u00bfQu\u00e9 es un BUCLE en VBA? En VBA, un LOOP es una estructura que puede repetir una instrucci\u00f3n. En [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/bucles\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:32:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.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\/bucles\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/bucles\/\",\"name\":\"Bucles vba: la gu\u00eda definitiva para principiantes\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/bucles\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/bucles\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.png\",\"datePublished\":\"2023-09-25T15:00:15+00:00\",\"dateModified\":\"2023-12-25T10:32:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/bucles\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/bucles\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/bucles\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/bucles\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bucles vba: la gu\u00eda definitiva para principiantes\"}]},{\"@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":"Bucles vba: la gu\u00eda definitiva para principiantes","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\/bucles\/","og_locale":"es_ES","og_type":"article","og_title":"Bucles vba: la gu\u00eda definitiva para principiantes","og_description":"Puntos importantes El uso de bucles en VBA puede resultar \u00fatil cuando desea realizar una tarea repetitiva. Tambi\u00e9n puedes usar un bucle dentro de otro bucle (anidamiento). Aseg\u00farate de tener cuidado al crear un bucle infinito. \u00bfQu\u00e9 es un BUCLE en VBA? En VBA, un LOOP es una estructura que puede repetir una instrucci\u00f3n. En [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/bucles\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:32:34+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.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\/bucles\/","url":"https:\/\/exceladvisor.org\/es\/bucles\/","name":"Bucles vba: la gu\u00eda definitiva para principiantes","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/bucles\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/bucles\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.png","datePublished":"2023-09-25T15:00:15+00:00","dateModified":"2023-12-25T10:32:34+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/bucles\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/bucles\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/bucles\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/bucles\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"Bucles vba: la gu\u00eda definitiva para principiantes"}]},{"@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\/717","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=717"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/717\/revisions"}],"predecessor-version":[{"id":1425,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/717\/revisions\/1425"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}