{"id":1514,"date":"2023-11-18T10:28:05","date_gmt":"2023-11-18T10:28:05","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/"},"modified":"2023-12-10T06:01:35","modified_gmt":"2023-12-10T06:01:35","slug":"makro-2yi-calistir","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/","title":{"rendered":"Excel&#39;de makro nas\u0131l \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-759475981\"><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\">Visual Basic for Applications (VBA), Microsoft Excel&#8217;in yan\u0131 s\u0131ra Word ve Access gibi di\u011fer Microsoft Office uygulamalar\u0131na entegre bir programlama dilidir. Excel&#8217;deki VBA kodu birka\u00e7 nedenden dolay\u0131 \u00f6nemlidir:<\/p><h2> Excel&#8217;de VBA kodunun \u00f6nemi<\/h2><p> <strong>Tekrarlanan g\u00f6revlerin otomasyonu<\/strong><\/p><p> VBA, kullan\u0131c\u0131lar\u0131n Excel&#8217;de tekrarlanan ve zaman alan g\u00f6revleri otomatikle\u015ftirmesine olanak tan\u0131r. Bu, veri i\u015fleme, bi\u00e7imlendirme ve rapor olu\u015fturmadan karma\u015f\u0131k hesaplamalara kadar her \u015feyi i\u00e7erebilir. VBA kodu yazarak, yaln\u0131zca bir tu\u015fa t\u0131klayarak bu g\u00f6revleri ger\u00e7ekle\u015ftirecek makrolar olu\u015fturabilirsiniz.<\/p><p> <strong>Geli\u015ftirilmi\u015f i\u015flevsellik:<\/strong><\/p><p> VBA, kullan\u0131c\u0131lar\u0131n Excel&#8217;in i\u015flevselli\u011fini yerle\u015fik \u00f6zelliklerinin \u00f6tesine geni\u015fletmesine olanak tan\u0131r. Kullan\u0131c\u0131larla etkile\u015fimde bulunmak ve daha kullan\u0131c\u0131 dostu bir deneyim sa\u011flamak i\u00e7in \u00f6zel i\u015flevler, kullan\u0131c\u0131 formlar\u0131 ve ileti\u015fim kutular\u0131 olu\u015fturabilirsiniz.<\/p><p> <strong>Veri analizi ve raporlama:<\/strong><\/p><p> VBA ile geli\u015fmi\u015f veri analizi ve raporlama ara\u00e7lar\u0131 geli\u015ftirebilirsiniz. Bu, verileri i\u00e7e aktarma, temizleme ve i\u015fleme s\u00fcrecinin otomatikle\u015ftirilmesinin yan\u0131 s\u0131ra kapsaml\u0131 raporlar ve g\u00f6sterge tablolar\u0131 olu\u015fturulmas\u0131n\u0131 da i\u00e7erebilir.<\/p><p> <strong>Di\u011fer uygulamalarla entegrasyon:<\/strong><\/p><p> VBA, Excel ile di\u011fer Microsoft Office uygulamalar\u0131n\u0131n yan\u0131 s\u0131ra harici uygulamalarla entegrasyonu kolayla\u015ft\u0131r\u0131r. Bu, \u00f6zellikle farkl\u0131 yaz\u0131l\u0131m ara\u00e7lar\u0131 veya birden fazla uygulamay\u0131 i\u00e7eren otomasyon s\u00fcre\u00e7leri aras\u0131nda veri aktarman\u0131z gerekti\u011finde kullan\u0131\u015fl\u0131d\u0131r.<\/p><p> <strong>Hata i\u015fleme ve hata ay\u0131klama:<\/strong><\/p><p> VBA, g\u00fc\u00e7l\u00fc hata i\u015fleme yetenekleri sa\u011flayarak, hatalar\u0131 incelikle i\u015fleyen ve anlaml\u0131 hata mesajlar\u0131 sa\u011flayan kod yazman\u0131za olanak tan\u0131r. Bu, kodunuzda sorun gidermeyi ve hata ay\u0131klamay\u0131 kolayla\u015ft\u0131r\u0131r.<\/p><p> Ve VBA ile pek \u00e7ok \u015fey yap\u0131labilir. <a href=\"https:\/\/exceladvisor.org\/tr\/vba\/\">Yeni ba\u015flayanlar i\u00e7in VBA kodu yazmak<\/a> biraz zor olabilir, ancak bunu nas\u0131l yapaca\u011f\u0131n\u0131z a\u015fa\u011f\u0131da a\u00e7\u0131klanm\u0131\u015ft\u0131r.<\/p><h2 class=\"wp-block-heading\"> 1. Listeden bir makro \u00e7al\u0131\u015ft\u0131r\u0131n<\/h2><p> <a href=\"https:\/\/exceladvisor.org\/tr\/gelistirici-sekmesi-ekle\/\">Geli\u015ftirici sekmesinden<\/a> \u00e7al\u0131\u015fma kitab\u0131n\u0131zda veya K\u0130\u015e\u0130SEL.XLSB&#8217;de bulunan MAKROS listesine eri\u015febilirsiniz. Excel&#8217;de makro \u00e7al\u0131\u015ft\u0131rmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz:<\/p><ol><li> \u201cGeli\u015ftirici\u201d sekmesindeki makro d\u00fc\u011fmesine t\u0131klay\u0131n ve makro listesini a\u00e7\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-listeden-bir-makro-\u00e7al\u0131\u015ft\u0131r\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-executer-une-macro-de-la-liste.png\" sizes=\"auto, \" srcset=\"\" alt=\"run-a-macro-from-the-list\" width=\"840\" height=\"166\"><\/li><li> Bu MAKROS listesinde, ki\u015fisel makro \u00e7al\u0131\u015fma kitab\u0131n\u0131z da dahil olmak \u00fczere a\u00e7\u0131k \u00e7al\u0131\u015fma kitaplar\u0131n\u0131zda bulunan t\u00fcm makrolara sahip olacaks\u0131n\u0131z. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-makro-ki\u015fisel-cilt\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-cahier-de-macro-personnel.png\" sizes=\"auto, \" srcset=\"\" alt=\"personal-macro-workbook\" width=\"463\" height=\"435\"><\/li><li> \u00c7al\u0131\u015ft\u0131rmak istedi\u011finiz makroyu se\u00e7in ve \u201c\u00c7ALI\u015eTIR\u201d butonuna t\u0131klay\u0131n.<\/li><\/ol><p> \u00c7al\u0131\u015ft\u0131r d\u00fc\u011fmesine t\u0131klad\u0131\u011f\u0131n\u0131zda makroyu \u00e7al\u0131\u015ft\u0131r\u0131r ve ileti\u015fim kutusunu kapat\u0131r.<\/p><h2 class=\"wp-block-heading\"> 2. K\u0131sayol tu\u015fuyla bir makro \u00e7al\u0131\u015ft\u0131r\u0131n<\/h2><p> Makroyu klavye k\u0131sayol tu\u015funu kullanarak da \u00e7al\u0131\u015ft\u0131rabilirsiniz. Genellikle <a href=\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/\">bir makro kaydetti\u011finizde<\/a> sizden o makroyu \u00e7al\u0131\u015ft\u0131rmak i\u00e7in kullanabilece\u011finiz bir k\u0131sayol tu\u015fu tan\u0131mlaman\u0131z istenir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50173\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-executer-une-macro-avec-une-touche-de-raccourci.png\" sizes=\"auto, \" srcset=\"\" alt=\"k\u0131sayol tu\u015fuyla bir makro \u00e7al\u0131\u015ft\u0131r\" width=\"390\" height=\"313\"><\/figure><\/div><p> Ve e\u011fer bir makro yazarsan\u0131z, makro listesinden bir <a href=\"https:\/\/exceladvisor.org\/tr\/klavye-kisayollari\/\">k\u0131sayol tu\u015fu<\/a> ayarlayabilirsiniz.<\/p><ol><li> K\u0131sayol tu\u015funu ayarlamak istedi\u011finiz makronun ad\u0131n\u0131 se\u00e7in ve se\u00e7eneklere t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-makro-ad\u0131 se\u00e7in\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-selectionnez-le-nom-de-la-macro.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-name-of-the-macro\" width=\"460\" height=\"432\"><\/li><li> Bundan sonra giri\u015f kutusunun i\u00e7ine t\u0131klay\u0131n ve ayarlamak istedi\u011finiz k\u0131sayol tu\u015funa bas\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"Giri\u015f kutusunda 5 t\u0131klama\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-cliquez-dans-la-zone-de-saisie.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-in-the-input-box\" width=\"393\" height=\"286\"><\/li><\/ol><h2 class=\"wp-block-heading\"> 3. H\u0131zl\u0131 Eri\u015fim Ara\u00e7 \u00c7ubu\u011funa Makro D\u00fc\u011fmesi Ekleyin<\/h2><p> Bir makroyu \u00e7al\u0131\u015ft\u0131rmak i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/hizli-erisim-cubugu\/\"><strong>H\u0131zl\u0131 Eri\u015fim Ara\u00e7 \u00c7ubu\u011funa<\/strong><\/a> bir d\u00fc\u011fme de ekleyebilirsiniz. A\u015fa\u011f\u0131daki ad\u0131mlar\u0131 kullanabilirsiniz:<\/p><ol><li> \u0130lk olarak, H\u0131zl\u0131 Eri\u015fim Ara\u00e7 \u00c7ubu\u011fu&#8217;ndaki k\u00fc\u00e7\u00fck a\u00e7\u0131l\u0131r listeye t\u0131klay\u0131n ve daha fazla komut se\u00e7in; bu sizi H\u0131zl\u0131 Eri\u015fim Ara\u00e7 \u00c7ubu\u011funu \u00f6zelle\u015ftirmek i\u00e7in ger\u00e7ek se\u00e7eneklere g\u00f6t\u00fcrecektir. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-h\u0131zl\u0131 eri\u015fim ara\u00e7 \u00e7ubu\u011funa bir makro d\u00fc\u011fmesi ekleme\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-ajouter-un-bouton-macro-a-la-barre-doutils-dacces-rapide.png\" sizes=\"auto, \" srcset=\"\" alt=\"add-a-macro-button-to-quick-access-toolbar\" width=\"253\" height=\"552\"><\/li><li> \u015eimdi buradan do\u011fruluk komut makrolar\u0131n\u0131 se\u00e7in ve eklemek istedi\u011finiz makroyu se\u00e7in, ard\u0131ndan Ekle d\u00fc\u011fmesine t\u0131klay\u0131n; h\u0131zl\u0131 eri\u015fim ara\u00e7 \u00e7ubu\u011fu yapmak i\u00e7in o makroyu ekleyecektir. <br><img loading=\"lazy\" decoding=\"async\" title=\"7-h\u0131zl\u0131-eri\u015fim-ara\u00e7 \u00e7ubu\u011funu \u00f6zelle\u015ftirme\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-personnaliser-la-barre-doutils-dacces-rapide.png\" sizes=\"auto, \" srcset=\"\" alt=\"customize-the-quick-access-toolbar\" width=\"498\" height=\"337\"><\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ol><p> Ve ekledi\u011finiz makro i\u00e7in bir d\u00fc\u011fmeniz olacak. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50178\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-bouton-pour-la-macro.png\" sizes=\"auto, \" srcset=\"\" alt=\"makro d\u00fc\u011fmesi\" width=\"258\" height=\"121\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 4. \u015eekle makro ekleme<\/h2><p> Diyelim ki i\u015finizde s\u0131kl\u0131kla kullanman\u0131z gereken baz\u0131 VBA kodunuz var. Bu durumda bir d\u00fc\u011fme olu\u015fturabilir ve bu makroyu ona atayabilirsiniz.<\/p><ol><li> \u00d6ncelikle Ekle sekmesinden \u279c \u00c7izimler \u279c \u015eekiller&#8217;den basit bir \u015fekil ekleyin. D\u00fc\u011fme olarak kullanmak istedi\u011finiz \u015fekillerden birini se\u00e7in. <br><img loading=\"lazy\" decoding=\"async\" title=\"9-\u015fekle makro ekleme\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-ajouter-une-macro-a-une-forme.png\" sizes=\"auto, \" srcset=\"\" alt=\"add-macro-to-a-shape\" width=\"464\" height=\"319\"><\/li><li> Daha sonra bu \u015fekle sa\u011f t\u0131klay\u0131n ve \u201cMakro Ata\u201d se\u00e7ene\u011fini se\u00e7in. <br><img loading=\"lazy\" decoding=\"async\" title=\"10-bu \u015fekle sa\u011f t\u0131klay\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-clic-droit-sur-cette-forme.png\" sizes=\"auto, \" srcset=\"\" alt=\"right-click-on-that-shape\" width=\"357\" height=\"218\"><\/li><li> \u015eimdi makro listesinden \u015fekle atamak istedi\u011finiz makroyu se\u00e7in. <br><img loading=\"lazy\" decoding=\"async\" title=\"11 makro listesi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-liste-de-macros.png\" sizes=\"auto, \" srcset=\"\" alt=\"list-of-macros\" width=\"547\" height=\"254\"><\/li><\/ol><p> Art\u0131k bu \u015fekle her t\u0131klad\u0131\u011f\u0131n\u0131zda atad\u0131\u011f\u0131n\u0131z makro \u00e7al\u0131\u015facakt\u0131r.<\/p><h2 class=\"wp-block-heading\"> 5. Form kontrol d\u00fc\u011fmesine bir makro atay\u0131n<\/h2><p> Bir \u015fekli kullanman\u0131n yan\u0131 s\u0131ra, bir makroyu \u00e7al\u0131\u015ft\u0131rmak i\u00e7in bir kontrol d\u00fc\u011fmesini de kullanabilirsiniz.<\/p><ol><li> \u00d6ncelikle Geli\u015ftirici sekmesine ve Kontroller grubuna gidin, ard\u0131ndan ekle&#8217;ye t\u0131klay\u0131n. Ekle a\u00e7\u0131l\u0131r kutusunda, eklemek i\u00e7in d\u00fc\u011fmeye t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"12-bir-form-kontrol d\u00fc\u011fmesine bir makro atay\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-affecter-une-macro-a-un-bouton-de-controle-de-formulaire.png\" sizes=\"auto, \" srcset=\"\" alt=\"assign-a-macro-to-a-form-control-button\" width=\"245\" height=\"304\"><\/li><li> Bundan sonra, se\u00e7ebilece\u011finiz makrolar\u0131n listesini size g\u00f6sterecektir. <br><img loading=\"lazy\" decoding=\"async\" title=\"13-makro-atama-ileti\u015fim kutusu\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-boite-de-dialogue-daffectation-de-macro.png\" sizes=\"auto, \" srcset=\"\" alt=\"assign-macro-dialog-box\" width=\"423\" height=\"399\"><\/li><li> Makroyu se\u00e7ip Tamam&#8217;\u0131 t\u0131klad\u0131\u011f\u0131n\u0131zda, e-tabloda bir d\u00fc\u011fme g\u00f6receksiniz (d\u00fc\u011fme metnini ona anlaml\u0131 bir ad verecek \u015fekilde de\u011fi\u015ftirebilirsiniz). <br><img loading=\"lazy\" decoding=\"async\" title=\"14-t\u0131klay\u0131n-tamam-bir-d\u00fc\u011fmeyi-alacaks\u0131n\u0131z\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-cliquez-sur-ok-vous-obtiendrez-un-bouton.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-ok-you-will-get-a-button\" width=\"279\" height=\"131\"><\/li><\/ol><h2 class=\"wp-block-heading\"> 6. Bir \u00e7al\u0131\u015fma kitab\u0131n\u0131 a\u00e7\u0131n ve kapat\u0131n<\/h2><p> Ayr\u0131ca bir \u00e7al\u0131\u015fma kitab\u0131n\u0131 a\u00e7arken ve kapat\u0131rken \u00e7al\u0131\u015ft\u0131r\u0131lacak bir makro da olu\u015fturabilirsiniz. Bu, bir \u00e7al\u0131\u015fma kitab\u0131n\u0131 a\u00e7t\u0131\u011f\u0131n\u0131zda veya kapatt\u0131\u011f\u0131n\u0131zda atad\u0131\u011f\u0131n\u0131z makronun y\u00fcr\u00fct\u00fclece\u011fi anlam\u0131na gelir. Bunu yapmak i\u00e7in \u201cauto_open\u201d ve \u201cauto_close\u201d kullanman\u0131z gerekir.<\/p><p> Diyelim ki \u00e7al\u0131\u015fma kitab\u0131 a\u00e7\u0131ld\u0131\u011f\u0131nda \u00e7al\u0131\u015facak bir makro atamak istiyorsunuz. Bu makronun ad\u0131 olarak auto_open kullanmal\u0131s\u0131n\u0131z. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub auto_open() Range(\"A1\").Value = Now End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50186\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-ouvrir-et-fermer-un-classeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir ciltleyiciyi a\u00e7 ve kapat\" width=\"271\" height=\"132\"><\/figure><\/div><p> Art\u0131k bu mikro, \u00e7al\u0131\u015fma kitab\u0131n\u0131 a\u00e7\u0131p ge\u00e7erli tarihi girdi\u011finizde, ard\u0131ndan etkin sayfan\u0131n A1 h\u00fccresine girdi\u011finizde \u00e7al\u0131\u015facakt\u0131r.<\/p><p> Benzer \u015fekilde \u00e7al\u0131\u015fma kitab\u0131n\u0131 kapat\u0131rken bu makroyu olu\u015fturmak i\u00e7in \u201cauto_close\u201d komutunu da kullanabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> 7. Bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 etkinle\u015ftirin ve devre d\u0131\u015f\u0131 b\u0131rak\u0131n<\/h2><p> T\u0131pk\u0131 \u00e7al\u0131\u015fma kitab\u0131n\u0131n bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 <a href=\"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/\">etkinle\u015ftirme<\/a> ve devre d\u0131\u015f\u0131 b\u0131rakma konusunda bir makro \u00e7al\u0131\u015ft\u0131rabilece\u011fi gibi. Ve bu durumda bu makroyu bu \u00e7al\u0131\u015fma sayfas\u0131n\u0131n kod penceresine eklemeniz gerekir.<\/p><ol><li> \u00d6ncelikle elektronik tablo sekmesine sa\u011f t\u0131klay\u0131n ve \u201cKodu G\u00f6ster\u201d se\u00e7ene\u011fine t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"16-bir-\u00e7al\u0131\u015fma sayfas\u0131n\u0131 etkinle\u015ftirme ve devre d\u0131\u015f\u0131 b\u0131rakma\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-activer-et-desactiver-une-feuille-de-travail.png\" sizes=\"auto, \" srcset=\"\" alt=\"activating-and-deactivating-a-worksheet\" width=\"219\" height=\"299\"><\/li><li> \u015eimdi kod penceresinde soldaki a\u00e7\u0131l\u0131r men\u00fcden \u00e7al\u0131\u015fma sayfas\u0131n\u0131 se\u00e7in. Devre d\u0131\u015f\u0131 b\u0131rakmak istedi\u011finizde; \u201cWorksheet_Deactivate\u201d ad\u0131nda yeni bir abone alacaks\u0131n\u0131z. <br><img loading=\"lazy\" decoding=\"async\" title=\"17-soldan-\u00e7al\u0131\u015fma sayfas\u0131n\u0131 se\u00e7 a\u00e7\u0131l\u0131r listesi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-selectionnez-la-feuille-de-calcul-dans-la-liste-deroulante-de-gauche.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-worksheet-from-the-left-dropdown\" width=\"684\" height=\"201\"><\/li><li> \u015eimdi, \u00e7al\u0131\u015fma sayfas\u0131n\u0131 devre d\u0131\u015f\u0131 b\u0131rakt\u0131\u011f\u0131n\u0131zda \u00e7al\u0131\u015ft\u0131rmak istedi\u011finiz kodu bu prosed\u00fcre eklemeniz gerekiyor.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Private Sub Worksheet_Deactivate() Range(\u201cA1\u201d).Value = Now End Sub<\/code><\/pre><p> Bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 etkinle\u015ftirdi\u011finizde bir makroyu \u00e7al\u0131\u015ft\u0131rmak istiyorsan\u0131z, a\u00e7\u0131l\u0131r listeden devre d\u0131\u015f\u0131 b\u0131rakmak yerine etkinle\u015ftirmeyi se\u00e7in. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50189\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/18-selectionner-activer-au-lieu-de-desactiver.png\" sizes=\"auto, \" srcset=\"\" alt=\"devre d\u0131\u015f\u0131 b\u0131rakmak yerine etkinle\u015ftirmeyi se\u00e7\" width=\"429\" height=\"169\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Private Sub Worksheet_Activate() Range(\u201cA1\u201d).Value = Now End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> 8. \u00c7al\u0131\u015fma sayfas\u0131ndaki bir de\u011fi\u015fiklikte makro \u00e7al\u0131\u015ft\u0131r\u0131n<\/h2><p> \u00c7al\u0131\u015fma sayfas\u0131nda de\u011fi\u015fiklik yapt\u0131\u011f\u0131n\u0131zda da makro \u00e7al\u0131\u015ft\u0131rabilirsiniz. \u00d6rne\u011fin bir h\u00fccreye de\u011fer girdi\u011finizde veya h\u00fccreden de\u011fer sildi\u011finizde.<\/p><p> Bunu yapmak i\u00e7in, \u00f6zelli\u011fi bir kez daha e-tablonun kod penceresine girmeniz ve a\u00e7\u0131l\u0131r listeden &#8220;Se\u00e7imi D\u00fczenle&#8221; se\u00e7ene\u011fini se\u00e7meniz gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50190\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/19-executer-une-macro-lors-dun-changement-de-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir-\u00e7al\u0131\u015fma sayfas\u0131-de\u011fi\u015fti\u011finde-makro-\u00e7al\u0131\u015ft\u0131r\" width=\"700\" height=\"148\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range(\u201cA1\u201d).Value = \u201cLast Updated: \u201d &amp; Format(Now, \u201cdd-mmm-yy hh:mm:ss Am\/pm\u201d) End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> 9. Ba\u015fka bir prosed\u00fcrde<\/h2><p> \u00c7a\u011fr\u0131 ifadesini kullanarak ba\u015fka bir prosed\u00fcrden bir makro \u00e7al\u0131\u015ft\u0131rabilirsiniz. \u00c7a\u011fr\u0131 anahtar s\u00f6zc\u00fc\u011f\u00fcn\u00fc ve ard\u0131ndan makronun ad\u0131n\u0131 kullan\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50191\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/20-dans-le-cadre-dune-autre-procedure.png\" sizes=\"auto, \" srcset=\"\" alt=\"ba\u015fka bir prosed\u00fcrde\" width=\"286\" height=\"222\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myStrikeThrough() If Selection.Value = \u201cYes\u201d Then Selection.Value = \u201cNo\u201d Else Selection.Value = \u201cYes\u201d End If End Sub Sub markDone() Call myStrikeThrough Selection.Font.Bold = True End Sub<\/code><\/pre><p> &#8220;markDone&#8221; makrosunu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, \u00f6nce &#8220;mystrikethrough&#8221; makrosunu \u00e7al\u0131\u015ft\u0131r\u0131r, ard\u0131ndan se\u00e7im yaz\u0131 tipini kal\u0131n yapar.<\/p><h2 class=\"wp-block-heading\"> 10. Bir makro planlay\u0131n<\/h2><p> Ayr\u0131ca bir makroyu belirli bir zamanda \u00e7al\u0131\u015facak \u015fekilde zamanlayabilirsiniz. Diyelim ki sabah 8:30\u2019da bir makro \u00e7al\u0131\u015ft\u0131rmak istiyorsunuz, saati siz belirtin biz \u00e7al\u0131\u015ft\u0131ral\u0131m.<\/p><p> Bunu yapmak i\u00e7in Application.OnTime y\u00f6ntemini kullanman\u0131z gerekir. Diyelim ki bir \u201cmyCode\u201d makronuz var, a\u015fa\u011f\u0131daki gibi bir kod yazarak onu 8:30\u2019da \u00e7al\u0131\u015ft\u0131rabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Application.OnTime TimeValue(\"08:30:00\"), \"myCode\"<\/code><\/pre><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\/gorusme-sorulari\/\">VBA M\u00fclakat Sorular\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yorum\/\">VBA koduna yorum ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/satir-sonu\/\">VBA koduna sat\u0131r sonu ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yeni-hat\/\">VBA&#8217;da bir dizeye yeni bir sat\u0131r (sat\u0131r ba\u015f\u0131) ekleyin<\/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-1514","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>\u25b7 Excel&#039;de VBA makrosu\/kodu nas\u0131l \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Yeni ba\u015flayanlar i\u00e7in VBA kodu yazmak biraz zor olabilir, ancak bu eksiksiz k\u0131lavuzu kullanarak bunu kolayca yapabilirsiniz.\" \/>\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\/makro-2yi-calistir\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Excel&#039;de VBA makrosu\/kodu nas\u0131l \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Yeni ba\u015flayanlar i\u00e7in VBA kodu yazmak biraz zor olabilir, ancak bu eksiksiz k\u0131lavuzu kullanarak bunu kolayca yapabilirsiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-executer-une-macro-de-la-liste.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=\"7 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/\",\"name\":\"\u25b7 Excel&#39;de VBA makrosu\/kodu nas\u0131l \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-executer-une-macro-de-la-liste.png\",\"datePublished\":\"2023-11-18T10:28:05+00:00\",\"dateModified\":\"2023-12-10T06:01:35+00:00\",\"description\":\"Yeni ba\u015flayanlar i\u00e7in VBA kodu yazmak biraz zor olabilir, ancak bu eksiksiz k\u0131lavuzu kullanarak bunu kolayca yapabilirsiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-executer-une-macro-de-la-liste.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-executer-une-macro-de-la-liste.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de makro nas\u0131l \u00e7al\u0131\u015ft\u0131r\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":"\u25b7 Excel&#39;de VBA makrosu\/kodu nas\u0131l \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r?","description":"Yeni ba\u015flayanlar i\u00e7in VBA kodu yazmak biraz zor olabilir, ancak bu eksiksiz k\u0131lavuzu kullanarak bunu kolayca yapabilirsiniz.","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\/makro-2yi-calistir\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Excel&#39;de VBA makrosu\/kodu nas\u0131l \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r?","og_description":"Yeni ba\u015flayanlar i\u00e7in VBA kodu yazmak biraz zor olabilir, ancak bu eksiksiz k\u0131lavuzu kullanarak bunu kolayca yapabilirsiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:35+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-executer-une-macro-de-la-liste.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"7 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/","url":"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/","name":"\u25b7 Excel&#39;de VBA makrosu\/kodu nas\u0131l \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-executer-une-macro-de-la-liste.png","datePublished":"2023-11-18T10:28:05+00:00","dateModified":"2023-12-10T06:01:35+00:00","description":"Yeni ba\u015flayanlar i\u00e7in VBA kodu yazmak biraz zor olabilir, ancak bu eksiksiz k\u0131lavuzu kullanarak bunu kolayca yapabilirsiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-executer-une-macro-de-la-liste.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-executer-une-macro-de-la-liste.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de makro nas\u0131l \u00e7al\u0131\u015ft\u0131r\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\/1514","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=1514"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1514\/revisions"}],"predecessor-version":[{"id":2541,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1514\/revisions\/2541"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}