{"id":2060,"date":"2023-10-21T13:45:37","date_gmt":"2023-10-21T13:45:37","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/"},"modified":"2023-12-10T06:07:37","modified_gmt":"2023-12-10T06:07:37","slug":"bu-arada-yapmak","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/","title":{"rendered":"Vba&#39;da do while d\u00f6ng\u00fcs\u00fc nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1912573289\"><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 Do while, bir ko\u015ful belirtmeniz gereken ve d\u00f6ng\u00fcn\u00fcn y\u00fcr\u00fct\u00fclmesi i\u00e7in bu ko\u015fulun do\u011fru kalmas\u0131 gereken bir d\u00f6ng\u00fcd\u00fcr. Basit bir ifadeyle, \u00f6ncelikle belirtti\u011finiz ko\u015fulun do\u011fru olup olmad\u0131\u011f\u0131n\u0131 kontrol eder ve e\u011fer ko\u015ful do\u011fruysa d\u00f6ng\u00fcy\u00fc \u00e7al\u0131\u015ft\u0131r\u0131r, aksi halde hi\u00e7bir \u015fey yapmaz.<\/p><p> Her yinelemede ko\u015fulu test eder ve ancak bundan sonra talimat\u0131 y\u00fcr\u00fct\u00fcr. Excel&#8217;e <a href=\"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/\">\u00e7al\u0131\u015fma sayfalar\u0131 eklemek<\/a> istedi\u011finizi ancak tam \u00e7al\u0131\u015fma sayfas\u0131 say\u0131s\u0131n\u0131n 12 veya daha az oldu\u011funu d\u00fc\u015f\u00fcn\u00fcn. Bu durumda bu kodu yazmak i\u00e7in do-while d\u00f6ng\u00fcs\u00fcn\u00fc kullanabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> Sonraki her d\u00f6ng\u00fc i\u00e7in VBA s\u00f6zdizimini burada bulabilirsiniz. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Do While Condition [statements] Loop<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51937\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-do-while-declaration-de-condition-de-boucle.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-do-while-d\u00f6ng\u00fcs\u00fc-ko\u015ful-ifadesi\" width=\"465\" height=\"283\"><\/figure><\/div><ol type=\"1\"><li> <strong>Ko\u015ful:<\/strong> Belirtti\u011finiz ko\u015fuldur ve d\u00f6ng\u00fcn\u00fcn y\u00fcr\u00fct\u00fclebilmesi i\u00e7in bu ko\u015fulun do\u011fru olmas\u0131 gerekir.<\/li><li> <strong>A\u00e7\u0131klama<\/strong> : Do While d\u00f6ng\u00fcs\u00fcn\u00fcn ko\u015fulu y\u00fcr\u00fctmesini istedi\u011finiz kod sat\u0131rlar\u0131 do\u011fru.<\/li><li> <strong>D\u00f6ng\u00fc<\/strong> : Bu, d\u00f6ng\u00fc yinelemesinin biti\u015f ifadesidir ve VBA&#8217;ya ko\u015fulu tekrar test etmek i\u00e7in geri d\u00f6nmesini s\u00f6yler.<\/li><\/ol><h3 class=\"wp-block-heading\"> DO While d\u00f6ng\u00fcs\u00fcn\u00fc anlamak i\u00e7in \u00f6rnek<\/h3><p> Do While D\u00f6ng\u00fcs\u00fcn\u00fc anlamak i\u00e7in toplam \u00e7al\u0131\u015fma sayfas\u0131 say\u0131s\u0131 on ikiden az oldu\u011funda \u00e7al\u0131\u015fma kitab\u0131na \u00e7al\u0131\u015fma sayfas\u0131 ekleyen bir kod yazal\u0131m. VBA&#8217;ya ka\u00e7 sayfa ekleyece\u011finizi s\u00f6ylemenize gerek yoktur ve bu kodu her \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda her zaman toplam 12 sayfan\u0131z olur.<\/p><p> A\u015fa\u011f\u0131daki ad\u0131mlar\u0131 kullan\u0131n:<\/p><ol><li> \u00d6ncelikle klavyede \u201cDo While\u201d yazman\u0131z gerekiyor. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-anahtar kelimeyi-yap-s\u0131ras\u0131nda-yaz\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-tapez-le-mot-cle-do-while.png\" sizes=\"auto, \" srcset=\"\" alt=\"type-the-keyword-do-while\" width=\"470\" height=\"235\"><\/li><li> Daha sonra, \u00e7al\u0131\u015fma kitab\u0131ndaki toplam \u00e7al\u0131\u015fma sayfas\u0131 say\u0131s\u0131n\u0131n on ikiden az olup olmad\u0131\u011f\u0131n\u0131 kontrol edebilecek bir ko\u015ful yazman\u0131z gerekir.<\/li><li> Bunu yapmak i\u00e7in, toplam \u00e7al\u0131\u015fma sayfas\u0131 say\u0131s\u0131n\u0131 sayan ve ard\u0131ndan bunu on iki say\u0131s\u0131yla kar\u015f\u0131la\u015ft\u0131ran a\u015fa\u011f\u0131daki kodu kullanman\u0131z gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"3 Ko\u015ful \u00c7al\u0131\u015fma Sayfas\u0131n\u0131 Kontrol Edin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-conditions-pour-verifier-les-feuilles-de-travail.png\" sizes=\"auto, \" srcset=\"\" alt=\"condition-to-check-worksheets\" width=\"534\" height=\"179\"><\/li><li> Daha sonra \u00e7al\u0131\u015fma sayfas\u0131 eklemek i\u00e7in kodu yazman\u0131z gerekir. Bu kod belirtti\u011finiz ko\u015ful do\u011fru oldu\u011funda \u00e7al\u0131\u015facakt\u0131r. <br><img loading=\"lazy\" decoding=\"async\" title=\"\u00c7al\u0131\u015fma sayfas\u0131na eklenecek 4 kod\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-code-pour-ajouter-une-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"code-to-add-worksheet\" width=\"591\" height=\"217\"><\/li><li> Ve sonunda kodu tamamlamak i\u00e7in \u201cD\u00f6ng\u00fc\u201d anahtar kelimesini yaz\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"5 tip d\u00f6ng\u00fcden biti\u015f koduna kadar\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Boucle-de-type-5-pour-terminer-le-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"type-loop-to-end-the-code\" width=\"565\" height=\"235\"><\/li><\/ol><p> \u0130\u015fte az \u00f6nce yazd\u0131\u011f\u0131n\u0131z kodun tamam\u0131:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_do_while_loop() Do While ActiveWorkbook.Worksheets.Count &lt; 12 Sheets.Add Loop End Sub<\/code><\/pre><p> \u015eimdi bu kodun nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 a\u00e7\u0131klayay\u0131m: <strong>Belirtti\u011finiz ko\u015ful, \u00e7al\u0131\u015fma kitab\u0131ndaki toplam \u00e7al\u0131\u015fma sayfas\u0131 say\u0131s\u0131n\u0131 kontrol eder<\/strong> ve ard\u0131ndan \u00e7al\u0131\u015fma sayfas\u0131 say\u0131s\u0131n\u0131 on ikiye g\u00f6re kontrol eden bir k\u00fc\u00e7\u00fckt\u00fcr operat\u00f6r\u00fcne sahip olursunuz.<\/p><p> <strong>\u00c7al\u0131\u015fma sayfas\u0131 say\u0131s\u0131 on ikiden az oldu\u011funda d\u00f6ng\u00fc \u00e7al\u0131\u015fmaya devam edecek<\/strong> ve yeni \u00e7al\u0131\u015fma sayfalar\u0131 eklemeye devam edecektir, ancak \u00e7al\u0131\u015fma sayfas\u0131 say\u0131s\u0131 on ikiye ula\u015ft\u0131\u011f\u0131nda d\u00f6ng\u00fc duracakt\u0131r.<\/p><p> Bu, basit bir ifadeyle, \u00e7al\u0131\u015fma sayfas\u0131 say\u0131s\u0131 on ikiden az oldu\u011fu s\u00fcrece d\u00f6ng\u00fcn\u00fcn \u00e7al\u0131\u015fmaya devam edece\u011fi anlam\u0131na gelir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62277\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-boucle-do-while.gif\" sizes=\"auto, \" srcset=\"\" alt=\"do-while d\u00f6ng\u00fcs\u00fc \u00f6rne\u011fi\" width=\"597\" height=\"395\"><\/figure><\/div><p> Olay \u015fu ki, az \u00f6nce yazd\u0131\u011f\u0131n\u0131z kodla eklemek istedi\u011finiz \u00e7al\u0131\u015fma sayfas\u0131 say\u0131s\u0131n\u0131 belirtmenize gerek yok, ancak bir sonraki d\u00f6ng\u00fcye giderseniz eklemek istedi\u011finiz \u00e7al\u0131\u015fma sayfas\u0131 say\u0131s\u0131 hesaplamas\u0131n\u0131 belirtmeniz gerekiyor.<\/p><h2 class=\"wp-block-heading\"> i\u00e7in bir d\u00f6ng\u00fc olu\u015ftur<\/h2><p> Do Loop While, Do While Loop&#8217;un geni\u015fletilmi\u015f bir versiyonudur \u00e7\u00fcnk\u00fc ayn\u0131 \u015fekilde \u00e7al\u0131\u015f\u0131r ancak durumu test ederken k\u00fc\u00e7\u00fck bir fark vard\u0131r.<\/p><p> Do Loop&#8217;ta Belirtti\u011finiz ko\u015fulu test etmeden \u00f6nce d\u00f6ng\u00fcn\u00fcn bir yinelemesini \u00e7al\u0131\u015ft\u0131r\u0131rken, ko\u015ful do\u011fruysa d\u00f6ng\u00fcye devam eder.<\/p><p> Diyelim ki bir \u015fifreyi kontrol etmek i\u00e7in bir kod yazmak ve \u015fifre yanl\u0131\u015fken d\u00f6ng\u00fcye devam etmek istiyorsunuz (bunu \u00f6rnekte g\u00f6r\u00fcyoruz).<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> \u0130\u015fte VBA Do Loop While&#8217;\u0131n s\u00f6zdizimi. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51942\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-syntaxe-pour-la-boucle-vba-do-while.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-do-loop-while i\u00e7in s\u00f6zdizimi\" width=\"457\" height=\"327\"><\/figure><\/div><ol type=\"1\"><li> Yap: Bu, Do While d\u00f6ng\u00fcs\u00fcn\u00fcn ba\u015flang\u0131\u00e7 anahtar kelimesidir.<\/li><li> A\u00e7\u0131klama: Bu, d\u00f6ng\u00fcde \u00e7al\u0131\u015ft\u0131rmak istedi\u011finiz kod sat\u0131rlar\u0131d\u0131r.<\/li><li> Loop While: D\u00f6ng\u00fcy\u00fc devam ettirecek ve belirtti\u011finiz ko\u015fulu test edecek anahtar kelimedir.<\/li><li> Ko\u015ful: Bu, d\u00f6ng\u00fc ikinci yinelemeye ba\u015flamadan ve d\u00f6ng\u00fcye devam etmeden \u00f6nce test etmek istedi\u011finiz ko\u015fuldur.<\/li><\/ol><p> Do Loop While&#8217;\u0131n s\u00f6z diziminde g\u00f6rebilece\u011finiz gibi, \u00f6nce deyimi bir kez \u00e7al\u0131\u015ft\u0131racak, ard\u0131ndan ko\u015fula giderek onu test edecek ve e\u011fer bu ko\u015ful do\u011fruysa d\u00f6ng\u00fcy\u00fc ba\u015flat\u0131p ko\u015ful devam etti\u011fi s\u00fcrece devam edecek. do\u011fru.<\/p><h3 class=\"wp-block-heading\"> DO d\u00f6ng\u00fcs\u00fcn\u00fc anlamak i\u00e7in \u00f6rnek while<\/h3><p> Do while d\u00f6ng\u00fcs\u00fcn\u00fc anlamak i\u00e7in, bir giri\u015f kutusu g\u00f6r\u00fcnt\u00fcleyecek ve kullan\u0131c\u0131dan \u015fifreyi girmesini isteyecek bir kod yazal\u0131m.<\/p><p> Bu giri\u015f kutusu, be\u015f denemeye kadar kullan\u0131c\u0131 taraf\u0131ndan girilen \u015fifrenin yanl\u0131\u015f oldu\u011funu a\u00e7\u0131k\u00e7a g\u00f6stermeye devam edecek ve bundan sonra giri\u015f kutusu, i\u015flem yap\u0131lmadan kaybolacakt\u0131r.<\/p><ol><li> \u0130lk olarak, \u015fifreyi saklaman\u0131z ve sayac\u0131 denemeniz i\u00e7in gereken iki de\u011fi\u015fkeni bildirin. <br><img loading=\"lazy\" decoding=\"async\" title=\"7-depolama i\u00e7in ihtiyac\u0131n\u0131z olan iki de\u011fi\u015fkeni bildirin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-declarer-deux-variables-dont-vous-avez-besoin-pour-le-stockage.png\" sizes=\"auto, \" srcset=\"\" alt=\"declare-two-variables-you-need-for-storing\" width=\"468\" height=\"181\"><\/li><li> Bundan sonra \u201cYap\u201d anahtar kelimesini yaz\u0131n. Burada s\u00f6zdiziminde g\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi ilk \u00f6nce ko\u015fulu tan\u0131mlaman\u0131za gerek yoktur. <br><img loading=\"lazy\" decoding=\"async\" title=\"8-yap\u0131lacak anahtar kelimeyi yaz\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-tapez-le-mot-cle-do.png\" sizes=\"auto, \" srcset=\"\" alt=\"type-the-do-keyword\" width=\"462\" height=\"174\"><\/li><li> Daha sonra, kullan\u0131c\u0131dan \u015fifreyi girmesini isteyen giri\u015f kutusunu g\u00f6r\u00fcnt\u00fclemek i\u00e7in bir kod sat\u0131r\u0131 yazman\u0131z gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"9-bir kod sat\u0131r\u0131 yazma\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-ecrire-une-ligne-de-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"write-a-line-of-code\" width=\"478\" height=\"213\"><\/li><li> Buradan be\u015fe kadar sayabilecek bir saya\u00e7 ayarlaman\u0131z gerekir (her d\u00f6ng\u00fc yinelemesinde toplan\u0131r). <br><img loading=\"lazy\" decoding=\"async\" title=\"10'lu saya\u00e7\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-definir-un-compteur.png\" sizes=\"auto, \" srcset=\"\" alt=\"define-a-counter\" width=\"508\" height=\"233\"><\/li><li> \u015eimdi \u201cLoop While\u201d anahtar kelimesini yaz\u0131n ve kullan\u0131c\u0131 taraf\u0131ndan giri\u015f kutusuna girilen de\u011feri kontrol edebilecek ve saya\u00e7 de\u011ferini 5&#8217;ten k\u00fc\u00e7\u00fckse test edebilecek iki ko\u015fulu ayarlay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"11-tip-anahtar kelime-d\u00f6ng\u00fcs\u00fc-while-ve-iki-ko\u015fulu tan\u0131mla\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-tapez-une-boucle-de-mots-cles-tandis-que-et-definissez-deux-conditions.png\" sizes=\"auto, \" srcset=\"\" alt=\"type-keyword-loop-while-and-define-two-condition\" width=\"519\" height=\"256\"><\/li><li> Son olarak \u00e7al\u0131\u015ft\u0131rmak istedi\u011finiz kodu yaz\u0131n. Burada, kullan\u0131c\u0131 taraf\u0131ndan girilen \u015fifrenin do\u011fru olmas\u0131 durumunda bir mesaj kutusu g\u00f6r\u00fcnt\u00fcleyecek olan IF ifadesini kullan\u0131yorum. <br><img loading=\"lazy\" decoding=\"async\" title=\"12-\u00e7al\u0131\u015ft\u0131rmak istedi\u011finiz kodu yaz\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-ecrivez-le-code-que-vous-voulez-executer.png\" sizes=\"auto, \" srcset=\"\" alt=\"write-the-code-you-want-to-run\" width=\"503\" height=\"306\"><\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_do_loop_while() Dim varPassword As Variant, i As Double Do varPassword = InputBox _ (\"Enter the password to start the procedure:\", _ \"Check Password 1.0\") i = i + 1 Loop While varPassword &lt;&gt; \"CorrectPassword\" And i &lt; 5 If varPassword = \"CorrectPassword\" Then MsgBox \"Your Password is Correct\" End If End Sub<\/code><\/pre><p> Bu kodu size a\u00e7\u0131klayay\u0131m.<\/p><ul><li> Bu kodun ilk k\u0131sm\u0131nda kullan\u0131c\u0131ya bir giri\u015f kutusu g\u00f6sterecek ve <strong>ondan \u015fifre isteyecek<\/strong> do while d\u00f6ng\u00fcs\u00fcne sahipsiniz.<\/li><li> <strong>\u015eifre yanl\u0131\u015fsa, kullan\u0131c\u0131 do\u011fru \u015fifreyi girene kadar d\u00f6ng\u00fcy\u00fc \u00e7al\u0131\u015ft\u0131rmaya devam edecektir<\/strong> .<\/li><li> Ancak d\u00f6ng\u00fcn\u00fcn yinelemelerini saymak i\u00e7in bir saya\u00e7 kulland\u0131\u011f\u0131n\u0131zdan ve <strong>bu saya\u00e7 5&#8217;e ula\u015ft\u0131\u011f\u0131nda d\u00f6ng\u00fc duracakt\u0131r<\/strong> .<\/li><\/ul><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\/donguler\/\">VBA D\u00f6ng\u00fcleri (Ba\u015flang\u0131\u00e7tan \u0130leri Seviyeye)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/davayi-sec\/\">VBA Se\u00e7me Vakas\u0131<\/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><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><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><li> <a href=\"https:\/\/exceladvisor.org\/tr\/1e-git\/\">GoTo VBA bildirimi<\/a><\/li><\/ul><\/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-2060","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&#039;da Do While D\u00f6ng\u00fcs\u00fc nas\u0131l kullan\u0131l\u0131r? (ve D\u00f6ng\u00fc Yap)<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde Excel&#039;de VBA kodunda Do While Loop ve Do Loop While&#039;\u0131n nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.\" \/>\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\/bu-arada-yapmak\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA&#039;da Do While D\u00f6ng\u00fcs\u00fc nas\u0131l kullan\u0131l\u0131r? (ve D\u00f6ng\u00fc Yap)\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde Excel&#039;de VBA kodunda Do While Loop ve Do Loop While&#039;\u0131n nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:07:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-do-while-declaration-de-condition-de-boucle.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=\"6 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/\",\"name\":\"VBA&#39;da Do While D\u00f6ng\u00fcs\u00fc nas\u0131l kullan\u0131l\u0131r? (ve D\u00f6ng\u00fc Yap)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-do-while-declaration-de-condition-de-boucle.png\",\"datePublished\":\"2023-10-21T13:45:37+00:00\",\"dateModified\":\"2023-12-10T06:07:37+00:00\",\"description\":\"Bu e\u011fitimde Excel&#39;de VBA kodunda Do While Loop ve Do Loop While&#39;\u0131n nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-do-while-declaration-de-condition-de-boucle.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-do-while-declaration-de-condition-de-boucle.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba&#39;da do while d\u00f6ng\u00fcs\u00fc nas\u0131l kullan\u0131l\u0131r?\"}]},{\"@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&#39;da Do While D\u00f6ng\u00fcs\u00fc nas\u0131l kullan\u0131l\u0131r? (ve D\u00f6ng\u00fc Yap)","description":"Bu e\u011fitimde Excel&#39;de VBA kodunda Do While Loop ve Do Loop While&#39;\u0131n nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.","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\/bu-arada-yapmak\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA&#39;da Do While D\u00f6ng\u00fcs\u00fc nas\u0131l kullan\u0131l\u0131r? (ve D\u00f6ng\u00fc Yap)","og_description":"Bu e\u011fitimde Excel&#39;de VBA kodunda Do While Loop ve Do Loop While&#39;\u0131n nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:07:37+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-do-while-declaration-de-condition-de-boucle.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"6 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/","url":"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/","name":"VBA&#39;da Do While D\u00f6ng\u00fcs\u00fc nas\u0131l kullan\u0131l\u0131r? (ve D\u00f6ng\u00fc Yap)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-do-while-declaration-de-condition-de-boucle.png","datePublished":"2023-10-21T13:45:37+00:00","dateModified":"2023-12-10T06:07:37+00:00","description":"Bu e\u011fitimde Excel&#39;de VBA kodunda Do While Loop ve Do Loop While&#39;\u0131n nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-do-while-declaration-de-condition-de-boucle.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-do-while-declaration-de-condition-de-boucle.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba&#39;da do while d\u00f6ng\u00fcs\u00fc nas\u0131l kullan\u0131l\u0131r?"}]},{"@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\/2060","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=2060"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2060\/revisions"}],"predecessor-version":[{"id":2941,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2060\/revisions\/2941"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2060"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}