{"id":2188,"date":"2023-09-25T15:00:15","date_gmt":"2023-09-25T15:00:15","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/donguler\/"},"modified":"2023-12-10T06:05:28","modified_gmt":"2023-12-10T06:05:28","slug":"donguler","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/donguler\/","title":{"rendered":"Vba d\u00f6ng\u00fcleri: yeni ba\u015flayanlar i\u0307\u00e7in m\u00fckemmel k\u0131lavuz"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1106422900\"><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>\u00d6nemli noktalar<\/strong><\/p><ol><li> Tekrarlanan bir g\u00f6revi ger\u00e7ekle\u015ftirmek istedi\u011finizde VBA&#8217;da d\u00f6ng\u00fcleri kullanmak yararl\u0131 olabilir.<\/li><li> Ayr\u0131ca ba\u015fka bir d\u00f6ng\u00fcn\u00fcn (yuvalama) i\u00e7indeki bir d\u00f6ng\u00fcy\u00fc de kullanabilirsiniz.<\/li><li> Sonsuz d\u00f6ng\u00fc olu\u015ftururken dikkatli olun.<\/li><\/ol><h2 class=\"wp-block-heading\"> VBA&#8217;da LOOP nedir?<\/h2><p> VBA&#8217;da LOOP, bir talimat\u0131 tekrarlayabilen bir yap\u0131d\u0131r. Basit\u00e7e s\u00f6ylemek gerekirse, bir d\u00f6ng\u00fc bir veya daha fazla aktiviteyi ger\u00e7ekle\u015ftirebilir ve belirli say\u0131da veya bir ko\u015ful kar\u015f\u0131lanana kadar tekrar ba\u015flamak i\u00e7in ba\u015flang\u0131ca d\u00f6nebilir. Bir d\u00f6ng\u00fcy\u00fc y\u00fcr\u00fctmenin bu d\u00f6ng\u00fcs\u00fcne yineleme denir. <\/p><div class=\"wp-block-image\"><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=\"vba-d\u00f6ng\u00fc-yap\u0131s\u01311\" width=\"499\" height=\"299\"><\/figure><\/div><h2 class=\"wp-block-heading\"> VBA&#8217;daki LOOP T\u00fcrleri<\/h2><p> VBA&#8217;da kullanabilece\u011finiz alt\u0131 farkl\u0131 d\u00f6ng\u00fc t\u00fcr\u00fc vard\u0131r ancak bunlar\u0131 iki temel kategoride de tan\u0131mlayabilirsiniz.<\/p><ol><li> <strong>Sonraki \u0130\u00e7in<\/strong> : FOR NEXT LOOP&#8217;u kullanmak i\u00e7in, d\u00f6ng\u00fcn\u00fcn y\u00fcr\u00fct\u00fclme say\u0131s\u0131 i\u00e7in saya\u00e7 olarak bir say\u0131 ayarlaman\u0131z gerekir. E\u011fer 10 kez d\u00f6ng\u00fc yapmak istiyorsan\u0131z saya\u00e7 i\u00e7in bu de\u011feri ayarlaman\u0131z gerekmektedir. <br><img loading=\"lazy\" decoding=\"async\" title=\"vba-sonraki d\u00f6ng\u00fc i\u00e7in\" 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><li> <strong>Her Biri \u0130\u00e7in<\/strong> : FOR EACH ile bir nesne koleksiyonundaki t\u00fcm nesnelere g\u00f6z atabilirsiniz. Her koleksiyonun belirli say\u0131da nesnesi oldu\u011fundan, bu onu sabit bir d\u00f6ng\u00fc haline getirir.<\/li><li> <strong>Do While D\u00f6ng\u00fcs\u00fc<\/strong> : Bir ko\u015fulu test eder ve bu ko\u015ful DO\u011eRU oldu\u011fu s\u00fcrece aktiviteyi ger\u00e7ekle\u015ftirmeye devam eder. Basit bir ifadeyle, \u00f6nce bir ko\u015fulu test eder ve yaln\u0131zca bu ko\u015fulun kar\u015f\u0131lanmas\u0131 durumunda ifadeyi \u00e7al\u0131\u015ft\u0131r\u0131r.<\/li><li> <strong>Do Loop While<\/strong> : &#8216;Do While&#8217; ile ayn\u0131 \u015fekilde \u00e7al\u0131\u015f\u0131r ancak \u00f6nce aktiviteyi yineler, ard\u0131ndan ko\u015fulu test eder ve e\u011fer bu ko\u015ful DO\u011eRU ise o aktiviteyi ger\u00e7ekle\u015ftirmeye devam eder.<\/li><li> <strong>Do Until Loop<\/strong> : Bir ko\u015fulu test eder ve ard\u0131ndan o ko\u015ful YANLI\u015e olana kadar tan\u0131mlad\u0131\u011f\u0131n\u0131z ifadeyi \u00e7al\u0131\u015ft\u0131rmaya devam eder ve ko\u015ful DO\u011eRU oldu\u011fu anda durur. Temel olarak &#8220;Do While&#8221;\u0131n tam tersidir.<\/li><li> <strong>Loop Until<\/strong> : Bu, \u201cDo Until\u201d ile ayn\u0131 \u015fekilde \u00e7al\u0131\u015f\u0131r, ancak \u00f6nce aktiviteyi yineler, ard\u0131ndan ko\u015fulu test eder ve e\u011fer bu ko\u015ful YANLI\u015e ise bu aktiviteyi ger\u00e7ekle\u015ftirmeye devam eder.<\/li><\/ol><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\/tr\/vba\/\">VBA nedir<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/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\/tr\/davayi-sec\/\">VBA Se\u00e7me Vakas\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/\">Excel VBA Do While D\u00f6ng\u00fcs\u00fc ve (Do Loop While) \u2013 Bir K\u0131lavuz<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dongu-yapraklari\/\">Excel&#8217;de VBA&#8217;y\u0131 kullanarak t\u00fcm sayfalar aras\u0131nda ge\u00e7i\u015f yap\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aralik-boyunca-dongu\/\">VBA (S\u00fctunlar, Sat\u0131r ve Kullan\u0131lm\u0131\u015fRange) kullanarak bir aral\u0131kta d\u00f6ng\u00fc yap\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/\">VBA FOR LOOP (Sonraki \u0130\u00e7in, Her Biri \u0130\u00e7in)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-2188","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>VBA D\u00f6ng\u00fcleri: 2023&#039;te Yeni Ba\u015flayanlar \u0130\u00e7in En \u0130yi K\u0131lavuz<\/title>\n<meta name=\"description\" content=\"Bir d\u00f6ng\u00fc bir veya daha fazla aktiviteyi ger\u00e7ekle\u015ftirebilir ve belirli say\u0131da tekrarlamak \u00fczere ba\u015flang\u0131ca d\u00f6nebilir.\" \/>\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\/tr\/donguler\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA D\u00f6ng\u00fcleri: 2023&#039;te Yeni Ba\u015flayanlar \u0130\u00e7in En \u0130yi K\u0131lavuz\" \/>\n<meta property=\"og:description\" content=\"Bir d\u00f6ng\u00fc bir veya daha fazla aktiviteyi ger\u00e7ekle\u015ftirebilir ve belirli say\u0131da tekrarlamak \u00fczere ba\u015flang\u0131ca d\u00f6nebilir.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/donguler\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:05:28+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=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/donguler\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/donguler\/\",\"name\":\"VBA D\u00f6ng\u00fcleri: 2023&#39;te Yeni Ba\u015flayanlar \u0130\u00e7in En \u0130yi K\u0131lavuz\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/donguler\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/donguler\/#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-10T06:05:28+00:00\",\"description\":\"Bir d\u00f6ng\u00fc bir veya daha fazla aktiviteyi ger\u00e7ekle\u015ftirebilir ve belirli say\u0131da tekrarlamak \u00fczere ba\u015flang\u0131ca d\u00f6nebilir.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/donguler\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/donguler\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/donguler\/#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\/tr\/donguler\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba d\u00f6ng\u00fcleri: yeni ba\u015flayanlar i\u0307\u00e7in m\u00fckemmel k\u0131lavuz\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA D\u00f6ng\u00fcleri: 2023&#39;te Yeni Ba\u015flayanlar \u0130\u00e7in En \u0130yi K\u0131lavuz","description":"Bir d\u00f6ng\u00fc bir veya daha fazla aktiviteyi ger\u00e7ekle\u015ftirebilir ve belirli say\u0131da tekrarlamak \u00fczere ba\u015flang\u0131ca d\u00f6nebilir.","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\/tr\/donguler\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA D\u00f6ng\u00fcleri: 2023&#39;te Yeni Ba\u015flayanlar \u0130\u00e7in En \u0130yi K\u0131lavuz","og_description":"Bir d\u00f6ng\u00fc bir veya daha fazla aktiviteyi ger\u00e7ekle\u015ftirebilir ve belirli say\u0131da tekrarlamak \u00fczere ba\u015flang\u0131ca d\u00f6nebilir.","og_url":"https:\/\/exceladvisor.org\/tr\/donguler\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:05:28+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":{"Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/donguler\/","url":"https:\/\/exceladvisor.org\/tr\/donguler\/","name":"VBA D\u00f6ng\u00fcleri: 2023&#39;te Yeni Ba\u015flayanlar \u0130\u00e7in En \u0130yi K\u0131lavuz","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/donguler\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/donguler\/#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-10T06:05:28+00:00","description":"Bir d\u00f6ng\u00fc bir veya daha fazla aktiviteyi ger\u00e7ekle\u015ftirebilir ve belirli say\u0131da tekrarlamak \u00fczere ba\u015flang\u0131ca d\u00f6nebilir.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/donguler\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/donguler\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/donguler\/#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\/tr\/donguler\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba d\u00f6ng\u00fcleri: yeni ba\u015flayanlar i\u0307\u00e7in m\u00fckemmel k\u0131lavuz"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=2188"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2188\/revisions"}],"predecessor-version":[{"id":2813,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2188\/revisions\/2813"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}