{"id":1492,"date":"2023-11-21T04:27:53","date_gmt":"2023-11-21T04:27:53","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/vba\/"},"modified":"2023-12-10T06:03:00","modified_gmt":"2023-12-10T06:03:00","slug":"vba","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/vba\/","title":{"rendered":"Excel&#39;de vba nedir? (temelden i\u0307leri d\u00fczey&#39;e)"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1587026572\"><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> <div class=\"wp-block-group group-one is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> VBA nedir?<\/h2><p> VBA (Visual Basic for Applications), Excel&#8217;deki hemen hemen her \u015feyi otomatikle\u015ftirmenize olanak tan\u0131yan bir programlama dilidir. VBA ile Excel nesnelerine ba\u015fvurabilir ve bunlarla ili\u015fkili \u00f6zellikleri, y\u00f6ntemleri ve olaylar\u0131 kullanabilirsiniz. \u00d6rne\u011fin, bir makro kullanarak bir pivot tablo olu\u015fturabilir, bir grafik ekleyebilir ve kullan\u0131c\u0131ya bir mesaj kutusu g\u00f6r\u00fcnt\u00fcleyebilirsiniz.<\/p><p> <strong>\u00c7\u0131lg\u0131n olan \u015fu:<\/strong><\/p><p> Manuel olarak dakikalar i\u00e7inde yapt\u0131\u011f\u0131n\u0131z t\u00fcm g\u00f6revleri VBA, tek t\u0131klamayla, ayn\u0131 hassasiyetle saniyeler i\u00e7inde ger\u00e7ekle\u015ftirebilir. Hatta bir belgeyi, \u00e7al\u0131\u015fma kitab\u0131n\u0131 a\u00e7t\u0131\u011f\u0131n\u0131zda ve hatta belirli bir zamanda otomatik olarak \u00e7al\u0131\u015fabilen VBA kodlar\u0131 yazabilirsiniz.<\/p><p> <strong>Size somut bir \u00f6rnek g\u00f6stereyim:<\/strong><\/p><p> Her sabah ofise gitti\u011fimde yapmam gereken ilk \u015fey, ayl\u0131k sat\u0131\u015flara ili\u015fkin bir pivot tablo olu\u015fturup bunu patronuma sunmak. Bu, her g\u00fcn ayn\u0131 ad\u0131mlar\u0131 i\u00e7erir. Ancak <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-1\/\" data-wpil=\"url\">VBA&#8217;y\u0131 kullanarak pivot tablo olu\u015fturup<\/a> onu tek t\u0131klamayla ekleyebilece\u011fimi fark etti\u011fimde bu bana g\u00fcnde 5 dakika kazand\u0131rd\u0131. <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5251\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Code-de-macro-a-utiliser-VBA-pour-creer-un-tableau-croise-dynamique-dans-Excel.gif\" sizes=\"auto, \" srcset=\"\" alt=\"Pivot tablo olu\u015fturmak i\u00e7in makro kodlar\u0131\" width=\"636\" height=\"344\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group group-one is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> VBA bu \u015fekilde \u00e7al\u0131\u015f\u0131r<\/h2><p> VBA nesne y\u00f6nelimli bir dildir ve nesne y\u00f6nelimli bir dil olarak VBA&#8217;da kodlar\u0131m\u0131z\u0131 nesneleri kullanacak ve sonra onlar\u0131n \u00f6zelliklerini tan\u0131mlayacak \u015fekilde yap\u0131land\u0131r\u0131r\u0131z.<\/p><p> Basit bir ifadeyle \u00f6nce nesneyi, sonra ger\u00e7ekle\u015ftirmek istedi\u011fimiz aktiviteyi tan\u0131mlar\u0131z. VBA&#8217;da kodunuzu yazmak i\u00e7in kullanabilece\u011finiz nesneler, koleksiyonlar, y\u00f6ntemler ve \u00f6zellikler vard\u0131r.<\/p><h3 class=\"wp-block-heading\"> &gt;Bunu ka\u00e7\u0131rmay\u0131n&lt;<\/h3><p> Diyelim ki birine bir kutuyu a\u00e7mas\u0131n\u0131 s\u00f6ylemek istiyorsunuz. Kullanaca\u011f\u0131n\u0131z kelimeler \u201cKutuyu a\u00e7\u201d olacakt\u0131r. Basit bir \u0130ngilizce, de\u011fil mi? Ancak konu VBA&#8217;ya ve makro yazmaya geldi\u011finde \u015f\u00f6yle olacakt\u0131r:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Box.Open<\/code><\/pre><p> G\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi yukar\u0131daki koda buradaki nesnemiz olan box ile ba\u015fl\u0131yoruz, daha sonra bunun i\u00e7in \u201cOpen\u201d metodunu kulland\u0131k. Biraz daha spesifik olal\u0131m, diyelim ki KIRMIZI renkli kutuyu a\u00e7mak istiyorsunuz. Ve bunun i\u00e7in kod \u015f\u00f6yle olacak:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Boxes(\u201cRed\u201d).Open<\/code><\/pre><p> Yukar\u0131daki kodda kutular koleksiyondur ve a\u00e7\u0131k y\u00f6ntemdir. Birden fazla kutunuz varsa burada belirli bir kutuyu tan\u0131mlar\u0131z. \u0130\u015fte ba\u015fka bir yol:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Box(\u201cRed\u201d).Unlock = True<\/code><\/pre><p> Yukar\u0131daki kodda, kutular yine koleksiyondur ve Kilit A\u00e7ma, TRUE olarak ayarlanan \u00f6zelliktir. <\/p><\/div><\/div><div class=\"wp-block-group group-one is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> VBA Excel&#8217;de ne i\u00e7in kullan\u0131l\u0131r?<\/h2><p> Excel&#8217;de VBA&#8217;y\u0131 farkl\u0131 \u015feyler i\u00e7in kullanabilirsiniz. \u0130\u015fte baz\u0131lar\u0131:<\/p><ul><li> <strong>Veri girin<\/strong> : Bir h\u00fccreye, bir h\u00fccre aral\u0131\u011f\u0131na veri girebilirsiniz. Ayr\u0131ca verileri bir b\u00f6l\u00fcmden di\u011ferine kopyalay\u0131p yap\u0131\u015ft\u0131rabilirsiniz.<\/li><li> <strong>G\u00f6rev otomasyonu<\/strong> : \u00c7ok fazla zaman harcaman\u0131z\u0131 gerektiren g\u00f6revleri otomatikle\u015ftirebilirsiniz. Verebilece\u011fim en iyi \u00f6rnek, pivot tablo olu\u015fturmak i\u00e7in makro kullanmakt\u0131r.<\/li><li> <strong>\u00d6zel bir Excel i\u015flevi olu\u015fturun<\/strong> : VBA ile ayr\u0131ca kullan\u0131c\u0131 tan\u0131ml\u0131 \u00f6zel bir i\u015flev olu\u015fturabilir ve bunu \u00e7al\u0131\u015fma sayfas\u0131nda kullanabilirsiniz.<\/li><li> <strong>Eklentiler Olu\u015fturun<\/strong> : Excel&#8217;de VBA kodlar\u0131n\u0131z\u0131 eklentilere d\u00f6n\u00fc\u015ft\u00fcrebilir ve bunlar\u0131 ba\u015fkalar\u0131yla da payla\u015fabilirsiniz.<\/li><li> <strong>Di\u011fer Microsoft uygulamalar\u0131yla entegre edin<\/strong> : Excel&#8217;i di\u011fer Microsoft uygulamalar\u0131yla da entegre edebilirsiniz. \u00d6rne\u011fin, bir metin dosyas\u0131na veri girebilirsiniz. <\/li><\/ul><\/div><\/div><div class=\"wp-block-group group-one is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Excel Programlama Temelleri<\/h2><h3 class=\"wp-block-heading\"> 1. Prosed\u00fcr<\/h3><p> VBA&#8217;daki prosed\u00fcr, belirli bir etkinli\u011fi ger\u00e7ekle\u015ftiren bir dizi kod veya tek bir kod sat\u0131r\u0131d\u0131r.<\/p><ol><li> <strong>SUB<\/strong> : Sub prosed\u00fcr\u00fc eylemleri ger\u00e7ekle\u015ftirebilir ancak bir de\u011fer d\u00f6nd\u00fcrmez (ancak bu de\u011feri elde etmek i\u00e7in bir nesne kullanabilirsiniz).<\/li><li> <strong>\u0130\u015flev<\/strong> : \u0130\u015flev prosed\u00fcr\u00fcn\u00fc kullanarak, elektronik tabloda veya di\u011fer SUB ve FUNCTION prosed\u00fcrlerinde kullanabilece\u011finiz i\u015flevinizi olu\u015fturursunuz (Buna bak\u0131n: <a href=\"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/\">VBA \u0130\u015flevi<\/a> ).<\/li><\/ol><h3 class=\"wp-block-heading\"> 2. De\u011fi\u015fkenler ve sabitler<\/h3><p> De\u011ferleri kodda birden \u00e7ok kez kullanmak i\u00e7in de\u011fi\u015fkenlere ve sabitlere ihtiyac\u0131n\u0131z vard\u0131r.<\/p><ul><li> <strong>De\u011fi\u015fken<\/strong> : Bir de\u011fi\u015fken bir de\u011fer saklayabilir, bir ad\u0131 vard\u0131r, veri t\u00fcr\u00fcn\u00fc tan\u0131mlaman\u0131z gerekir ve saklad\u0131\u011f\u0131 de\u011feri de\u011fi\u015ftirebilirsiniz. Ad\u0131ndan da anla\u015f\u0131laca\u011f\u0131 gibi \u201cDE\u011e\u0130\u015eKEN\u201din sabit bir de\u011feri yoktur. Sistemde saklanan bir saklama kutusu gibidir.<\/li><li> <strong>Sabit<\/strong> : Bir sabit ayn\u0131 zamanda bir de\u011fer de saklayabilir ancak kodu \u00e7al\u0131\u015ft\u0131r\u0131rken de\u011feri de\u011fi\u015ftiremezsiniz.<\/li><\/ul><h3 class=\"wp-block-heading\"> 3. Veri t\u00fcrleri<\/h3><p> DE\u011e\u0130\u015eKENLER ve SAB\u0130TLER i\u00e7in veri t\u00fcr\u00fcn\u00fc bildirmeniz gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-34302\" title=\"veri t\u00fcr\u00fcn\u00fc ayarla\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/definir-le-type-de-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"define data type\" width=\"518\" height=\"222\"><\/figure><\/div><p> Bir de\u011fi\u015fken veya sabit i\u00e7in veri tipini belirtti\u011finizde verilerinizin ge\u00e7erlili\u011fi sa\u011flan\u0131r. Veri t\u00fcr\u00fcn\u00fc atlarsan\u0131z VBA, De\u011fi\u015fken veri t\u00fcr\u00fcn\u00fc de\u011fi\u015fkeninize uygular (bu en esnek olan\u0131d\u0131r), VBA veri t\u00fcr\u00fcn\u00fcn ne olmas\u0131 gerekti\u011fini tahmin etmez.<\/p><p> <strong>\u0130pucu: <a href=\"https:\/\/exceladvisor.org\/tr\/acik-secenek-2\/\">A\u00e7\u0131k VBA se\u00e7ene\u011fi<\/a><\/strong><\/p><h3 class=\"wp-block-heading\"> 4. Nesneler, \u00f6zellikler ve y\u00f6ntemler<\/h3><p> Visual Basic for Applications, nesne y\u00f6nelimli bir dildir ve bundan en iyi \u015fekilde yararlanmak i\u00e7in; Excel nesnelerini anlaman\u0131z gerekir.<\/p><p> Excel&#8217;de kulland\u0131\u011f\u0131n\u0131z \u00e7al\u0131\u015fma kitab\u0131 farkl\u0131 nesneler i\u00e7erir ve bu nesnelerin hepsinde eri\u015febilece\u011finiz \u00e7e\u015fitli \u00f6zellikler ve kullanabilece\u011finiz y\u00f6ntemler vard\u0131r.<\/p><h3 class=\"wp-block-heading\"> 5. Etkinlikler<\/h3><p> Excel&#8217;de yapt\u0131\u011f\u0131n\u0131z her \u015fey bir olayd\u0131r: h\u00fccreye bir de\u011fer girin, yeni bir \u00e7al\u0131\u015fma sayfas\u0131 ekleyin veya bir grafik ekleyin. Olaylar\u0131n nesnelere g\u00f6re s\u0131n\u0131fland\u0131r\u0131lmas\u0131 a\u015fa\u011f\u0131da verilmi\u015ftir:<\/p><ol><li> <strong>Uygulama Olaylar\u0131:<\/strong> Bu olaylar Excel uygulamas\u0131n\u0131n kendisiyle ili\u015fkilidir.<\/li><li> \u00c7al\u0131\u015fma kitab\u0131 olaylar\u0131: Bu olaylar, \u00e7al\u0131\u015fma kitab\u0131nda meydana gelen eylemlerle ili\u015fkilidir.<\/li><li> \u00c7al\u0131\u015fma sayfas\u0131 olaylar\u0131: Bu olaylar, \u00e7al\u0131\u015fma sayfas\u0131nda meydana gelen eylemle ili\u015fkilidir.<\/li><li> <strong>Grafik olaylar\u0131:<\/strong> Bu olaylar (\u00e7al\u0131\u015fma sayfalar\u0131ndan farkl\u0131 olan) grafik sayfalar\u0131yla ili\u015fkilidir.<\/li><li> <strong>Kullan\u0131c\u0131 formu olaylar\u0131:<\/strong> Bu olaylar, bir kullan\u0131c\u0131 formuyla meydana gelen eylemle ili\u015fkilidir.<\/li><li> OnTime Olaylar\u0131: OnTime olaylar\u0131, kodu belirli bir zamanda tetikleyebilen olaylard\u0131r.<\/li><li> <strong>OnKey Olaylar\u0131:<\/strong> OnKey olaylar\u0131, belirli bir tu\u015fa bas\u0131ld\u0131\u011f\u0131nda bir kodu tetikleyebilen olaylard\u0131r.<\/li><\/ol><h3 class=\"wp-block-heading\"> 6. Kapsam<\/h3><p> Aral\u0131k nesnesi, VBA kodlar\u0131n\u0131zdaki bir aral\u0131\u011fa g\u00f6nderme yapman\u0131n en yayg\u0131n ve pop\u00fcler yoludur. H\u00fccre adresine ba\u015fvurman\u0131z gerekiyor, size s\u00f6zdizimini anlatay\u0131m.<\/p><pre class=\"wp-block-preformatted\"> Worksheets(\u201cSheet1\u201d).Range(\u201cA1\u201d)<\/pre><h3 class=\"wp-block-heading\"> 7.Ko\u015fullar<\/h3><p> Di\u011fer programlama dilleri gibi VBA&#8217;da da ko\u015fullar\u0131 test etmek i\u00e7in kodlar yazabilirsiniz. Bunu iki farkl\u0131 \u015fekilde yapman\u0131za olanak sa\u011flar.<\/p><ul><li> <strong><a href=\"https:\/\/exceladvisor.org\/tr\/eger-2\/\">IF THEN\u200c ELSE\u200c<\/a> :<\/strong> Bu, bir ko\u015fulu test etmek ve ard\u0131ndan bu ko\u015fulun DO\u011eRU olmas\u0131 durumunda bir kod sat\u0131r\u0131n\u0131 y\u00fcr\u00fctmek i\u00e7in kullanabilece\u011finiz bir IF ifadesidir. Yuvalama ko\u015fullar\u0131n\u0131 \u015fununla da yazabilirsiniz:<\/li><li> <strong><a href=\"https:\/\/exceladvisor.org\/tr\/davayi-sec\/\">SELEC\u200cT\u200c CASE<\/a><\/strong> : Se\u00e7me durumunda, y\u00fcr\u00fct\u00fclecek farkl\u0131 kod sat\u0131rlar\u0131n\u0131 y\u00fcr\u00fctmek i\u00e7in bir ko\u015ful ve ard\u0131ndan farkl\u0131 test sonucu durumlar\u0131 belirleyebilirsiniz. IF ifadesinden biraz daha yap\u0131land\u0131r\u0131lm\u0131\u015ft\u0131r.<\/li><\/ul><h3 class=\"wp-block-heading\"> 8. VBA D\u00f6ng\u00fcleri<\/h3><p> VBA&#8217;da bir eylemi tekrarlay\u0131p tekrarlayabilen kodlar yazabilirsiniz ve bunun gibi kod yazman\u0131n birka\u00e7 yolu vard\u0131r.<\/p><ul><li> <strong>For Next<\/strong> : For Next&#8217;i kullanmak i\u00e7in en uygun durum, bir dizi eylemi sabit say\u0131da tekrarlamak istedi\u011finiz zamand\u0131r.<\/li><li> <strong>Her Sonraki \u0130\u00e7in<\/strong> : Bir nesne koleksiyonundan bir grup nesne \u00fczerinde yineleme yapmak istedi\u011finizde kullanmak m\u00fckemmeldir.<\/li><li> Do While D\u00f6ng\u00fcs\u00fc: Do While D\u00f6ng\u00fcs\u00fcn\u00fcn ard\u0131ndaki basit fikir, bir ko\u015ful do\u011fruyken bir aktivite ger\u00e7ekle\u015ftirmektir.<\/li><li> D\u00f6ng\u00fcye Kadar Yap: Kadar Yap D\u00f6ng\u00fcs\u00fcnde, VBA bir d\u00f6ng\u00fc y\u00fcr\u00fct\u00fcr ve ko\u015ful YANLI\u015e ise y\u00fcr\u00fctmeye devam eder.<\/li><\/ul><h3 class=\"wp-block-heading\"> 9. Giri\u015f kutusu ve mesaj kutusu<\/h3><ul><li> <strong>Giri\u015f Kutusu<\/strong> : Giri\u015f Kutusu, kullan\u0131c\u0131ya bir giri\u015f kutusu g\u00f6r\u00fcnt\u00fcleyen ve yan\u0131t toplayan bir i\u015flevdir.<\/li><li> <strong><a href=\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/\">Mesaj Kutusu<\/a><\/strong> : Mesaj Kutusu, kullan\u0131c\u0131ya bir mesaj g\u00f6r\u00fcnt\u00fclemenize yard\u0131mc\u0131 olur, ancak kullan\u0131c\u0131dan yan\u0131t almak i\u00e7in mesaj kutusuna d\u00fc\u011fmeler ekleme se\u00e7ene\u011finiz de vard\u0131r.<\/li><\/ul><h3 class=\"wp-block-heading\"> 10. Hatalar<\/h3><p> Programlama hatalar\u0131 s\u00f6z konusu oldu\u011funda Excel \u015fanss\u0131zd\u0131r ve ne olursa olsun onlarla u\u011fra\u015fman\u0131z gerekir.<\/p><ol><li> <strong>S\u00f6zdizimi Hatalar\u0131<\/strong> : Bunlar kod yazarken yapt\u0131\u011f\u0131n\u0131z yaz\u0131m hatalar\u0131 gibidir ancak VBA bu hatalar\u0131 bildirerek size yard\u0131mc\u0131 olabilir.<\/li><li> Derleme hatalar\u0131: Bunlar, bir aktiviteyi ger\u00e7ekle\u015ftirmek i\u00e7in kod yazd\u0131\u011f\u0131n\u0131zda, ancak bu aktivite ge\u00e7ersiz oldu\u011funda ortaya \u00e7\u0131kar.<\/li><li> <strong>\u00c7al\u0131\u015fma Zaman\u0131 Hatalar\u0131<\/strong> : Kod y\u00fcr\u00fctme s\u0131ras\u0131nda bir RUNTIME hatas\u0131 olu\u015fur. Kodu durdurur ve hata ileti\u015fim kutusunu g\u00f6r\u00fcnt\u00fcler.<\/li><li> <strong>Mant\u0131ksal hata<\/strong> : Bir hata de\u011fil, kod yazarken olu\u015fan bir hatad\u0131r ve bazen bulma ve d\u00fczeltme konusunda size s\u0131k\u0131nt\u0131 ya\u015fatabilir.<\/li><\/ol><\/div><\/div><h2 class=\"wp-block-heading\"> Excel&#8217;de bir makro (VBA program\u0131) yaz\u0131n<\/h2><p> Birisi Excel&#8217;de programlamaya ba\u015flad\u0131\u011f\u0131nda, HE\/SHE&#8217;nin s\u0131f\u0131rdan giderek daha fazla kod yazmas\u0131 gerekti\u011fine dair g\u00fc\u00e7l\u00fc bir inanc\u0131m var. S\u0131f\u0131rdan ne kadar \u00e7ok kod yazarsan\u0131z VBA&#8217;n\u0131n nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 o kadar \u00e7ok anlars\u0131n\u0131z.<\/p><p> Ancak karma\u015f\u0131k kodlara atlamak yerine basit kodlar yazarak ba\u015flamal\u0131s\u0131n\u0131z. \u0130\u015fte bu y\u00fczden \u015fu anda karma\u015f\u0131k hi\u00e7bir \u015fey d\u00fc\u015f\u00fcnmenizi istemiyorum.<\/p><p> Pivot tablo olu\u015fturmak i\u00e7in makro kodu bile yazabilirsiniz ama \u015fu anda bu kadar d\u00fc\u015f\u00fcnmenizi istemiyorum. Elektronik tablonuzda yapmak istedi\u011finiz bir aktiviteyi d\u00fc\u015f\u00fcnelim ve bunun i\u00e7in kod yazabilirsiniz.<\/p><ol><li> <a href=\"https:\/\/exceladvisor.org\/tr\/gelistirici-sekmesi-ekle\/\">Geli\u015ftirici sekmesine<\/a> gidin ve \u201cVisual Basic\u201d butonundan <a href=\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/\">Visual Basic D\u00fczenleyiciyi<\/a> a\u00e7\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-g\u00f6rsel-temel-d\u00fc\u011fme\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-bouton-de-base-visuel.png\" sizes=\"auto, \" srcset=\"\" alt=\"visual-basic-button\" width=\"245\" height=\"128\"><\/li><li> Daha sonra \u201cProje Penceresi\u201dnden yeni bir mod\u00fcl ekleyin (Sa\u011f T\u0131k \uf0e0 Ekle \uf0e0 Mod\u00fcl). <br><img loading=\"lazy\" decoding=\"async\" title=\"2-yeni-mod\u00fcl ekle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-inserer-un-nouveau-module.png\" sizes=\"auto, \" srcset=\"\" alt=\"insert-a-new-module\" width=\"326\" height=\"235\"><\/li><li> Daha sonra kod penceresine gelin ve a\u015fa\u011f\u0131da yapt\u0131\u011f\u0131m gibi \u201cEnter Done\u201d isminde bir makro olu\u015fturun (SUB prosed\u00fcr\u00fc olu\u015fturuyoruz). <br><img loading=\"lazy\" decoding=\"async\" title=\"3 kod penceresi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/fenetre-a-3-codes.png\" sizes=\"auto, \" srcset=\"\" alt=\"code-window\" width=\"385\" height=\"140\"><\/li><li> Oradan yukar\u0131da bahsetti\u011fimiz baz\u0131 kodlar\u0131 yazman\u0131z gerekiyor. Bir saniye bekleyip \u015f\u00f6yle d\u00fc\u015f\u00fcn\u00fcn: De\u011feri eklemek istedi\u011finiz h\u00fccreyi, ard\u0131ndan girmek istedi\u011finiz de\u011feri belirtmeniz gerekiyor.<\/li><li> H\u00fccre referans\u0131n\u0131 girin ve bunun i\u00e7in RANGE nesnesini kullanman\u0131z ve oradaki h\u00fccre adresini a\u015fa\u011f\u0131daki gibi belirtmeniz gerekir: <br><img loading=\"lazy\" decoding=\"async\" title=\"4 H\u00fccre Referans Aral\u0131\u011f\u0131 Nesnesi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Objet-de-plage-de-reference-a-4-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"cell-reference-range-object\" width=\"244\" height=\"151\"><\/li><li> Bundan sonra bir nokta girin ve bir nokta ekledi\u011finiz anda, ayarlayabilece\u011finiz \u00f6zelliklerin ve aral\u0131kta yapabilece\u011finiz etkinliklerin bir listesine sahip olacaks\u0131n\u0131z. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-bir-d\u00f6nem-giri\u015f\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-entrez-un-point.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-a-dot\" width=\"277\" height=\"188\"><\/li><li> Buradan \u201cValue\u201d \u00f6zelli\u011fini se\u00e7ip \u201cA1\u201d h\u00fccresine eklemek istedi\u011finiz metni ayarlaman\u0131z gerekiyor ve bunu yapt\u0131\u011f\u0131n\u0131zda kodunuz a\u015fa\u011f\u0131daki gibi g\u00f6r\u00fcnecek. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-de\u011fer se\u00e7\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-selectionner-la-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-value\" width=\"300\" height=\"152\"><\/li><li> Son olarak, kod sat\u0131r\u0131n\u0131n \u00fcst\u00fcne metni girin (\u201cbu kod, A5 h\u00fccresine \u201cBitti\u201d de\u011ferini girer). Bu, yazd\u0131\u011f\u0131n\u0131z kod sat\u0131r\u0131n\u0131 tan\u0131mlamak i\u00e7in ekleyebilece\u011finiz bir <a href=\"https:\/\/exceladvisor.org\/tr\/yorum\/\">VBA yorumudur<\/a> . <br><img loading=\"lazy\" decoding=\"async\" title=\"7-kod sat\u0131r\u0131n\u0131n \u00fcst\u00fcndeki metni girin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-entrez-le-texte-au-dessus-du-code-de-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-the-text-above-line-code\" width=\"407\" height=\"176\"><\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub Enter_Done() 'this code enters the value \u201cDone\u201d in the cell A5 Range(\"A1\").Value = \"Done\" End Sub<\/code><\/pre><h3 class=\"wp-block-heading\"> Bunu anlayal\u0131m\u2026<\/h3><p> Bu kodu iki farkl\u0131 par\u00e7aya b\u00f6lebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51107\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comprendre-le-programme-excel-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"487\" height=\"195\"><\/figure><\/div><ul><li> <strong>FIRST<\/strong> k\u0131sm\u0131nda RANGE nesnesini kullanarak <strong>h\u00fccre adresini belirledik<\/strong> . Ayr\u0131ca, aral\u0131k nesnesini kullanarak bir h\u00fccreye at\u0131fta bulunmak i\u00e7in, h\u00fccre adresini \u00e7ift t\u0131rnak i\u00e7ine alman\u0131z gerekir (k\u00f6\u015feli parantez de kullanabilirsiniz).<\/li><li> \u0130K\u0130NC\u0130 b\u00f6l\u00fcmde h\u00fccreye girilecek de\u011feri belirttik. Yapt\u0131\u011f\u0131n\u0131z \u015fey, \u201c.Value\u201d kullanarak A5 h\u00fccresi i\u00e7in de\u011fer \u00f6zelli\u011fini ayarlad\u0131n\u0131z. Bundan sonra belirtti\u011finiz bir sonraki \u015fey, <strong>value \u00f6zelli\u011fine g\u00f6re de\u011ferdir<\/strong> . Bir de\u011feri tan\u0131mlad\u0131\u011f\u0131n\u0131zda (e\u011fer metin ise), bu de\u011feri \u00e7ift t\u0131rnak i\u00e7ine alman\u0131z gerekir.<\/li><\/ul><h2 class=\"wp-block-heading\"> VBA&#8217;y\u0131 \u00d6\u011frenmenin En \u0130yi Yolu<\/h2><p> Burada VBA&#8217;y\u0131 k\u0131sa s\u00fcrede \u00f6\u011frenmenize yard\u0131mc\u0131 olabilecek en harika e\u011fitimlerden baz\u0131lar\u0131n\u0131 (belirli bir s\u0131rayla de\u011fil) listeledim.<\/p><ul><li> En Faydal\u0131 100 Excel [VBA] Makro Kodu \u00d6rnekleri<\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/\">VBA Kullanarak Excel&#8217;de Kullan\u0131c\u0131 Tan\u0131ml\u0131 \u0130\u015flev [UDF] Nas\u0131l Olu\u015fturulur<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/gorusme-sorulari\/\">VBA M\u00fclakat Sorular\u0131<\/a> <\/li><\/ul><div id=\"ub-content-toggle-b15fc96f-300c-48ab-a45f-00efc2d41171\" class=\"wp-block-ub-content-toggle myList\" data-preventcollapse=\"true\" data-mobilecollapse=\"false\" data-desktopcollapse=\"false\"><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-disabled=\"true\" aria-expanded=\"true\" aria-controls=\"ub-content-toggle-panel-0-b15fc96f-300c-48ab-a45f-00efc2d41171\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-b15fc96f-300c-48ab-a45f-00efc2d41171\"> 1. VBA&#8217;ya ba\u015flarken <\/h3><\/div><div id=\"ub-content-toggle-panel-0-b15fc96f-300c-48ab-a45f-00efc2d41171\" class=\"wp-block-ub-content-toggle-accordion-content-wrap\" role=\"region\"><ul style=\"list-style-type: circle;\"><li> <a href=\"https:\/\/exceladvisor.org\/tr\/gelistirici-sekmesi-ekle\/\">Geli\u015ftirici Sekmesi Ekle<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/\">Visual Basic D\u00fczenleyicisi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yorum\/\">VBA&#8217;ya 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\/\">Yeni bir sat\u0131r ekle (sat\u0131r ba\u015f\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/\">Excel&#8217;de makro \u00e7al\u0131\u015ft\u0131rma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/\">Ki\u015fisel Makro \u00c7al\u0131\u015fma Kitab\u0131 (ki\u015fisel.xlsb)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/\">Excel&#8217;de makro kaydetme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/altinda-cikti\/\">VBA \u00e7\u0131kt\u0131 alt ifadesi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aninda-pencere-hata-ayiklama-baskisi\/\">VBA Acil Penceresi (Debug.Print)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/modul\/\">VBA mod\u00fcl\u00fc<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/\">VBA Mesaj Kutusu (MsgBox)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/nesneler\/\">VBA Nesneleri<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ile\/\">beyan\u0131 ile VBA<\/a> <\/li><\/ul><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-disabled=\"true\" aria-expanded=\"true\" aria-controls=\"ub-content-toggle-panel-1-b15fc96f-300c-48ab-a45f-00efc2d41171\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-b15fc96f-300c-48ab-a45f-00efc2d41171\"> 2. VBA&#8217;da \u00e7al\u0131\u015fma kitaplar\u0131yla \u00e7al\u0131\u015fma <\/h3><\/div><div id=\"ub-content-toggle-panel-1-b15fc96f-300c-48ab-a45f-00efc2d41171\" class=\"wp-block-ub-content-toggle-accordion-content-wrap\" role=\"region\"><ul style=\"list-style-type: circle;\"><li> <a href=\"https:\/\/exceladvisor.org\/tr\/baglayici\/\">VBA \u00c7al\u0131\u015fma Kitab\u0131 Nesnesini Anlamak<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/excel-dosyasini-kopyala\/\">VBA kullanarak bir Excel dosyas\u0131n\u0131 (\u00e7al\u0131\u015fma kitab\u0131n\u0131) kopyalama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/calisma-kitabini-etkinlestir\/\">\u00c7al\u0131\u015fma kitab\u0131n\u0131 etkinle\u015ftirin (Excel dosyas\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/calisma-kitabini-kapat\/\">\u00c7al\u0131\u015fma kitab\u0131n\u0131 kapat\u0131n (Excel dosyas\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/calisma-kitaplarini-birlestir\/\">\u00c7al\u0131\u015fma kitaplar\u0131n\u0131 birle\u015ftirme (Excel dosyalar\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/calisma-kitabi-olustur\/\">Yeni bir \u00e7al\u0131\u015fma kitab\u0131 olu\u015fturun (Excel dosyas\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dosyayi-sil\/\">\u00c7al\u0131\u015fma kitab\u0131n\u0131 sil (Excel dosyas\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/acik-dosya-dolabi\/\">\u00c7al\u0131\u015fma kitab\u0131n\u0131 a\u00e7 (Excel dosyas\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/calisma-kitabini-koru\/\">\u00c7al\u0131\u015fma kitab\u0131n\u0131 koruyun\/korumas\u0131n\u0131 kald\u0131r\u0131n (Excel dosyas\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/calisma-kitabini-yeniden-adlandir\/\">\u00c7al\u0131\u015fma kitab\u0131n\u0131 yeniden adland\u0131r\u0131n (Excel dosyas\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/calisma-kitabini-kaydet\/\">\u00c7al\u0131\u015fma kitab\u0131n\u0131 kaydedin (Excel dosyas\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bu-defter\/\">ThisWorkbook (ge\u00e7erli Excel dosyas\u0131)<\/a> <\/li><\/ul><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-disabled=\"true\" aria-expanded=\"true\" aria-controls=\"ub-content-toggle-panel-2-b15fc96f-300c-48ab-a45f-00efc2d41171\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-b15fc96f-300c-48ab-a45f-00efc2d41171\"> 3. Elektronik tablolarla \u00e7al\u0131\u015f\u0131n <\/h3><\/div><div id=\"ub-content-toggle-panel-2-b15fc96f-300c-48ab-a45f-00efc2d41171\" class=\"wp-block-ub-content-toggle-accordion-content-wrap\" role=\"region\"><ul style=\"list-style-type: circle;\"><li> <a href=\"https:\/\/exceladvisor.org\/tr\/calisma-sayfasi-1\/\">VBA&#8217;da Excel elektronik tablosuyla \u00e7al\u0131\u015fma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/temiz-sayfa\/\">Excel&#8217;de VBA kullanarak bir sayfan\u0131n tamam\u0131n\u0131 temizleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfayi-kopyala\/\">VBA Kullanarak Excel&#8217;de Bir Sayfay\u0131 Kopyalama ve Ta\u015f\u0131ma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/\">Excel&#8217;de VBA kullanarak sayfalar\u0131 COUNT etme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bir-sayfayi-sil-1\/\">Excel&#8217;de VBA kullanarak bir SAYFAYI S\u0130LME<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfayi-gizle\/\">Excel&#8217;de VBA kullanarak bir sayfay\u0131 gizleme ve g\u00f6sterme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/\">Excel&#8217;de VBA kullanarak bir sayfay\u0131 KORUMA ve KORUMADAN KALDIRMA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfayi-yeniden-adlandir\/\">Excel&#8217;de VBA Kullanarak Bir Sayfay\u0131 Yeniden Adland\u0131rma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/\">Excel&#8217;de Yeni Bir Sayfa Olu\u015fturmak i\u00e7in VBA Kodu Nas\u0131l Yaz\u0131l\u0131r (Makro)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/\">VBA kullanarak bir sayfa nas\u0131l etkinle\u015ftirilir<\/a> <\/li><\/ul><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-disabled=\"true\" aria-expanded=\"true\" aria-controls=\"ub-content-toggle-panel-3-b15fc96f-300c-48ab-a45f-00efc2d41171\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-b15fc96f-300c-48ab-a45f-00efc2d41171\"> 4. Aral\u0131k ve h\u00fccrelerle \u00e7al\u0131\u015fma <\/h3><\/div><div id=\"ub-content-toggle-panel-3-b15fc96f-300c-48ab-a45f-00efc2d41171\" class=\"wp-block-ub-content-toggle-accordion-content-wrap\" role=\"region\"><ul style=\"list-style-type: circle;\"><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aralik-1\/\">VBA&#8217;da Aral\u0131k ve H\u00fccrelerle \u00c7al\u0131\u015fmak<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/\">Excel&#8217;de VBA kullanarak sat\u0131rlar\u0131 sayma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/karakter-yazi-tipi\/\">Excel VBA yaz\u0131 tipi (renk, boyut, t\u00fcr ve kal\u0131n)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sutun-satirini-gosteri-gizle\/\">Excel VBA Bir s\u00fctunu veya sat\u0131r\u0131 gizleyin ve g\u00f6sterin<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sinirlar\/\">Excel&#8217;de VBA kullanarak bir h\u00fccreye kenarl\u0131klar nas\u0131l uygulan\u0131r<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/son-satirin-sutununun-hucresini-bulun\/\">Excel&#8217;de VBA kullanarak son sat\u0131r\u0131, s\u00fctunu ve h\u00fccreyi bulma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bir-satir-ekle-1\/\">Excel&#8217;de VBA kullanarak sat\u0131r nas\u0131l eklenir<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/birlestirmek\/\">VBA kodunu kullanarak Excel&#8217;deki h\u00fccreleri birle\u015ftirme<\/a><\/li><li> Excel&#8217;de VBA kullanarak bir aral\u0131k\/h\u00fccre nas\u0131l se\u00e7ilir<\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hepsini-sec\/\">VBA kullanarak bir \u00e7al\u0131\u015fma sayfas\u0131ndaki T\u00dcM h\u00fccreleri SE\u00c7ME<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aktif-hucre-1\/\">Excel&#8217;de VBA&#8217;da ActiveCell nas\u0131l kullan\u0131l\u0131r<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ozel-hucreler\/\">Excel&#8217;de VBA&#8217;da \u00d6zel H\u00fccreler Y\u00f6ntemi Nas\u0131l Kullan\u0131l\u0131r<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/\">Excel&#8217;de VBA&#8217;da UseRange \u00f6zelli\u011fi nas\u0131l kullan\u0131l\u0131r?<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-ayarlama-1\/\">VBA otomatik s\u0131\u011fd\u0131rma (sat\u0131rlar, s\u00fctunlar veya \u00e7al\u0131\u015fma sayfas\u0131n\u0131n tamam\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/icerigi-temizle-1\/\">VBA ClearContents (bir h\u00fccreden, aral\u0131ktan veya \u00e7al\u0131\u015fma sayfas\u0131n\u0131n tamam\u0131ndan)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hucreyi-yeni-calisma-sayfasina-kopyala\/\">VBA aral\u0131\u011f\u0131n\u0131 ba\u015fka bir sayfaya + \u00e7al\u0131\u015fma kitab\u0131na kopyala<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hucre-degeri\/\">VBA H\u00fccreye bir de\u011fer girin (Ayarla, Al ve De\u011fi\u015ftir)<\/a><\/li><li> VBA Ekleme S\u00fctunu (Tekli ve \u00c7oklu)<\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/isimli-plaj\/\">Aral\u0131k adl\u0131 VBA | (Statik + Se\u00e7im + Dinamik)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/menzil-kaymasi\/\">VBA Aral\u0131\u011f\u0131 Uzakl\u0131\u011f\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/\">VBA s\u0131ralama aral\u0131\u011f\u0131 | (Azalan, birden \u00e7ok s\u00fctun, s\u0131ralama y\u00f6n\u00fc<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/metni-kaydir-1\/\">VBA Sarma Metni (h\u00fccre, aral\u0131k ve \u00e7al\u0131\u015fma sayfas\u0131n\u0131n tamam\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/\">VBA kodlar\u0131n\u0131 kullanarak Excel&#8217;de yinelenen de\u011ferler nas\u0131l vurgulan\u0131r<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kopru-baglantisini-cikar\/\">VBA UDF kullanarak Excel&#8217;de k\u00f6pr\u00fc adresi (URL) nas\u0131l \u00e7\u0131kar\u0131l\u0131r<\/a> <\/li><\/ul><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-disabled=\"true\" aria-expanded=\"true\" aria-controls=\"ub-content-toggle-panel-4-b15fc96f-300c-48ab-a45f-00efc2d41171\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-b15fc96f-300c-48ab-a45f-00efc2d41171\"> 5. De\u011fi\u015fkenler ve sabitler <\/h3><\/div><div id=\"ub-content-toggle-panel-4-b15fc96f-300c-48ab-a45f-00efc2d41171\" class=\"wp-block-ub-content-toggle-accordion-content-wrap\" role=\"region\"><ul style=\"list-style-type: circle;\"><li> <a href=\"https:\/\/exceladvisor.org\/tr\/degiskenler\/\">VBA de\u011fi\u015fkenleri (beyan, veri t\u00fcrleri ve kapsam)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sabitler\/\">Sabit VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kuresel-degisken\/\">VBA&#8217;da global (genel) bir de\u011fi\u015fken bildirin<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/degisken-aralik\/\">VBA&#8217;da bir aral\u0131k veya h\u00fccre de\u011fi\u015fken olarak nas\u0131l kullan\u0131l\u0131r?<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/acik-secenek-2\/\">VBA&#8217;da a\u00e7\u0131k se\u00e7enek ifadesi nas\u0131l kullan\u0131l\u0131r?<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/degisken-mesaj-kutusu\/\">Mesaj kutusundaki de\u011fi\u015fken<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zayif\/\">Lo\u015f VBA talimat\u0131<\/a> <\/li><\/ul><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-disabled=\"true\" aria-expanded=\"true\" aria-controls=\"ub-content-toggle-panel-5-b15fc96f-300c-48ab-a45f-00efc2d41171\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-b15fc96f-300c-48ab-a45f-00efc2d41171\"> 6. Bukleler <\/h3><\/div><div id=\"ub-content-toggle-panel-5-b15fc96f-300c-48ab-a45f-00efc2d41171\" class=\"wp-block-ub-content-toggle-accordion-content-wrap\" role=\"region\"><ul style=\"list-style-type: circle;\"><li> <a href=\"https:\/\/exceladvisor.org\/tr\/donguler\/\">VBA d\u00f6ng\u00fcleri<\/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 Kullanarak T\u00fcm Sayfalarda Nas\u0131l Ge\u00e7i\u015f Yap\u0131l\u0131r<\/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) \u2013 K\u0131lavuz + \u00f6rnekler<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/1e-git\/\">GoTo VBA bildirimi<\/a> <\/li><\/ul><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-disabled=\"true\" aria-expanded=\"true\" aria-controls=\"ub-content-toggle-panel-6-b15fc96f-300c-48ab-a45f-00efc2d41171\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-b15fc96f-300c-48ab-a45f-00efc2d41171\"> 7.Ko\u015fullar <\/h3><\/div><div id=\"ub-content-toggle-panel-6-b15fc96f-300c-48ab-a45f-00efc2d41171\" class=\"wp-block-ub-content-toggle-accordion-content-wrap\" role=\"region\"><ul style=\"list-style-type: circle;\"><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-2\/\">VBA IF \u2013 IF Then Else Bildirimi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kontrol-sayfasi-mevcut\/\">Excel&#8217;de VBA kullan\u0131larak bir sayfan\u0131n mevcut olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/\">VBA Bir h\u00fccrenin bo\u015f + birden fazla h\u00fccre olup olmad\u0131\u011f\u0131n\u0131 kontrol edin<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/calisma-kitabinin-olup-olmadigini-kontrol-edin\/\">VBA Bir klas\u00f6rde \u00e7al\u0131\u015fma kitab\u0131n\u0131n olup olmad\u0131\u011f\u0131n\u0131 kontrol edin (Excel dosyas\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/acik-calisma-kitabini-kontrol-et\/\">VBA Bir \u00e7al\u0131\u015fma kitab\u0131n\u0131n a\u00e7\u0131k olup olmad\u0131\u011f\u0131n\u0131 kontrol edin (Excel dosyas\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-disari-cik\/\">VBA \u00c7\u0131k\u0131\u015f\u0131 IF<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-ve\/\">VBA IF And (\u00e7oklu ko\u015ful testi)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/\">HAYIR \u0130SE VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-veya\/\">VBA IF OR (\u00e7oklu test ko\u015fullar\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yuva-eger\/\">VBA i\u00e7 i\u00e7e IF<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/davayi-sec\/\">VBA SELECT CASE ifadesi (birden fazla ko\u015fulu test edin)<\/a> <\/li><\/ul><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-disabled=\"true\" aria-expanded=\"true\" aria-controls=\"ub-content-toggle-panel-7-b15fc96f-300c-48ab-a45f-00efc2d41171\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-b15fc96f-300c-48ab-a45f-00efc2d41171\"> 8. Hesaplamalar <\/h3><\/div><div id=\"ub-content-toggle-panel-7-b15fc96f-300c-48ab-a45f-00efc2d41171\" class=\"wp-block-ub-content-toggle-accordion-content-wrap\" role=\"region\"><ul style=\"list-style-type: circle;\"><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ortalama-2\/\">VBA kullanarak Excel&#8217;deki de\u011ferlerin ortalamas\u0131 nas\u0131l al\u0131n\u0131r?<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bugunun-tarihi-simdiki-saat\/\">VBA kullanarak bug\u00fcn\u00fcn tarihi ve \u015fimdiki saati nas\u0131l al\u0131n\u0131r?<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-1\/\">VBA Kullanarak Excel&#8217;e De\u011ferler Nas\u0131l Eklenir?<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/mac-2\/\">VBA&#8217;da e\u015fle\u015fme i\u015flevi nas\u0131l kullan\u0131l\u0131r?<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/mod-1\/\">VBA&#8217;da MOD nas\u0131l kullan\u0131l\u0131r<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/rastgele-sayi\/\">Rastgele say\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hesaplamak\/\">VBA hesaplamas\u0131 (h\u00fccre, aral\u0131k, sat\u0131r ve \u00e7al\u0131\u015fma kitab\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zincir-1\/\">VBA&#8217;y\u0131 birle\u015ftir<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/elektronik-tablo-islevi\/\">VBA \u00c7al\u0131\u015fma Sayfas\u0131 \u0130\u015flevi (Makroda Excel \u0130\u015flevlerini Kullanma)<\/a> <\/li><\/ul><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-disabled=\"true\" aria-expanded=\"true\" aria-controls=\"ub-content-toggle-panel-8-b15fc96f-300c-48ab-a45f-00efc2d41171\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-b15fc96f-300c-48ab-a45f-00efc2d41171\"> 9. Tablolar <\/h3><\/div><div id=\"ub-content-toggle-panel-8-b15fc96f-300c-48ab-a45f-00efc2d41171\" class=\"wp-block-ub-content-toggle-accordion-content-wrap\" role=\"region\"><ul style=\"list-style-type: circle;\"><li> <a href=\"https:\/\/exceladvisor.org\/tr\/resim-sergisi\/\">VBA Tablosu<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/\">VBA diziye yeni de\u011fer ekle<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dizi-boyutu\/\">VBA dizisi uzunlu\u011fu (boyut)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/\">Dizelerle VBA dizisi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tahtayi-sil\/\">VBA Diziyi Temizle<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dinamik-tablo\/\">Dinamik tablo VBA&#8217;s\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/vba-dongu-dizisi\/\">Bir dizideki VBA d\u00f6ng\u00fcs\u00fc<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cok-boyutlu-dizi\/\">\u00c7ok boyutlu dizi VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/plajin-bir-tablosu-var\/\">Bir diziye VBA aral\u0131\u011f\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/\">Bir dizide bir de\u011fer i\u00e7in VBA aramas\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/\">VBA \u00e7\u0131kt\u0131 tablosu<\/a> <\/li><\/ul><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-disabled=\"true\" aria-expanded=\"true\" aria-controls=\"ub-content-toggle-panel-9-b15fc96f-300c-48ab-a45f-00efc2d41171\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-b15fc96f-300c-48ab-a45f-00efc2d41171\"> 10. Hatalar <\/h3><\/div><div id=\"ub-content-toggle-panel-9-b15fc96f-300c-48ab-a45f-00efc2d41171\" class=\"wp-block-ub-content-toggle-accordion-content-wrap\" role=\"region\"><ul style=\"list-style-type: circle;\"><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/\">VBA hata i\u015fleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/otomasyon-hatasi-440\/\">VBA otomasyon hatas\u0131 (Hata 440)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hata-400\/\">VBA hatas\u0131 400<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/gecersiz-prosedur-cagrisi-veya-bagimsiz-degisken-hatasi-5\/\">Ge\u00e7ersiz VBA prosed\u00fcr\u00fc \u00e7a\u011fr\u0131s\u0131 veya ba\u011f\u0131ms\u0131z de\u011fi\u015fken hatas\u0131 (Hata 5)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/nesne-bu-ozelligi-veya-yontemi-desteklemiyor-hatasi-438\/\">VBA nesnesi bu \u00f6zelli\u011fi veya y\u00f6ntem hatas\u0131n\u0131 desteklemiyor (Hata 438)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/nesne-gerekli-hata-424\/\">VBA Nesnesi Gerekli Hatas\u0131 (Hata 424)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yetersiz-bellek-hatasi-7\/\">VBA Bellek Yetersiz Hatas\u0131 (Hata 7)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/\">VBA ta\u015fma hatas\u0131 (Hata 6)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/\">VBA \u00c7al\u0131\u015fma Zaman\u0131 Hatas\u0131 (Hata 1004)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dizin-hatasi-9-araliginin-disinda\/\">VBA Dizini Y\u00fcr\u00fctme Hatas\u0131 Aral\u0131k D\u0131\u015f\u0131nda (Hata 9)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/uyumsuzluk-hatasi-turu-13\/\">VBA t\u00fcr\u00fc uyumsuzluk hatas\u0131 (Hata 13)<\/a> <\/li><\/ul><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-disabled=\"true\" aria-expanded=\"true\" aria-controls=\"ub-content-toggle-panel-10-b15fc96f-300c-48ab-a45f-00efc2d41171\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-b15fc96f-300c-48ab-a45f-00efc2d41171\"> 11. \u0130\u015flevler <\/h3><\/div><div id=\"ub-content-toggle-panel-10-b15fc96f-300c-48ab-a45f-00efc2d41171\" class=\"wp-block-ub-content-toggle-accordion-content-wrap\" role=\"region\"><ul style=\"list-style-type: circle;\"><li> <a href=\"https:\/\/exceladvisor.org\/tr\/islevler\/\">Ana VBA i\u015flevleri<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/karin-kaslari-1\/\" data-wpil=\"url\">VBA ABS i\u015flevi (mutlak de\u011fer elde edin)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dagitmak\/\">VBA dizi i\u015flevi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/atn\/\">VBA ATN i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bool\/\">VBA CBOOL i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cbyte\/\">VBA CBYTE i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/meydana\/\">VBA CCUR i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih\/\">VBA CDATE i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cdbl\/\">VBA CDBL i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cdec\/\">VBA CDEC i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/saat\/\">VBA CHR i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/biraz\/\">VBA CINT i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sarilmak\/\">VBA CLNG i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cunku\/\">VBA COS i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/csng\/\">VBA CSNG i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cstr\/\">VBA CSTR i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cvar\/\">VBA CVAR i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cverr\/\">VBA CVERR i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-2\/\">VBA DATE i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-ekleme\/\">VBA DATEADD i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-bolumu\/\">VBA DATEPART i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-dizisi\/\">VBA DATESERIAL i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-degeri\/\">VBA DATEVALUE i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/gun\/\">VBA DAY i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ddb\/\">VBA DDB i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tecrube\/\">VBA EXP i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dosyatarihisaat\/\">VBA FileDateTime i\u015flevi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/filtre\/\">VBA FILTER i\u015flevi (S\u00f6zdizimi + \u00d6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/duzeltmek\/\">VBA FIX i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bicim\/\">VBA FORMAT i\u015flevi (S\u00f6zdizimi + \u00d6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bicim-para-birimi\/\">VBA FORMATCURRENCY i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/formattarihsaat\/\">VBA FORMATDATETIME i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/format-numarasi\/\">VBA FORMATNUMBER i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/format-yuzdesi\/\">VBA FORMATPERCENT i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/fv2\/\">VBA FV i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/altigen\/\">VBA HEX i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> VBA HOUR i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger\/\">VBA IIF i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> VBA INSTR i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/enstrev\/\">VBA INSTRREV i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/int\/\">VBA INT i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ipmt\/\">VBA IPMT i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kusura-bakma\/\">VBA IRR i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dizi\/\">VBA ISARRAY i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> VBA ISDATE i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bos\/\">VBA ISEMPTY i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hata\/\">VBA ISERROR i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kayip\/\">VBA ISMISSING i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> VBA ISNULL i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayisal\/\">VBA ISNUMERIC i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/es-nesne\/\">VBA ISOBJECT i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/katilmak\/\">VBA JOIN i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sinir-disi\/\">VBA LBOUND i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/durumda\/\">VBA LCASE i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sol\/\">VBA LEFT i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/vba-len\/\">VBA LEN i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/vba-gunlugu\/\">VBA LOG i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kisa-sure\/\">VBA LTRIM i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/oglen\/\">VBA MID i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/2.-dakika\/\">VBA MINUTE i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ayna\/\">VBA MIRR i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ay\/\">VBA AY i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ay-adi\/\">VBA MONTHNAME i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/simdi\/\">VBA \u015e\u0130MD\u0130 i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hayir\/\">VBA NPER i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/npv\/\">VBA NPV i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ekim\/\">VBA OCT i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pmt-2\/\">VBA PMT i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ppmt\/\">VBA PPMT i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hp-2\/\">VBA PV i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kacirildi\/\">VBA RATE i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yer-degistirmek\/\">VBA REPLACE i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sag\/\">VBA RIGHT i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/rnd\/\">VBA RND i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yuvarlak\/\">VBA ROUND i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/rtrim\/\">VBA RTRIM i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ikinci\/\">VBA \u0130K\u0130NC\u0130 i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/isaret\/\">VBA SGN i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/gunah\/\">VBA SIN i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sln\/\">VBA SLN i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/uzay\/\">VBA SPACE i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bolmek\/\">VBA SPLIT i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kare\/\">VBA SQR i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cadde\/\">VBA STR i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/strcomp\/\">VBA STRCOMP i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/strconv\/\">VBA STRCONV i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sicim\/\">VBA STRING i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ters\/\">VBA STRREVERSE i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/syd\/\">VBA SYD i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bronzluk\/\">VBA TAN i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zaman\/\">VBA TIME i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zamanlayici\/\">VBA TIMER i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zaman-serisi\/\">VBA TIMESERIAL i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zaman-degeri\/\">VBA TIMEVALUE i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/duzeltme\/\">VBA TRIM i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yukariya-dogru\/\">VBA UBOUND i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ucase\/\">VBA UCASE i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/val\/\">VBA VAL i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hafta-sonu\/\">VBA WEEKDAY i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hafta-ici-adi\/\">VBA WEEKDAYNAME i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yil\/\">VBA YIL i\u015flevi (s\u00f6zdizimi + \u00f6rnek)<\/a> <\/li><\/ul><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-disabled=\"true\" aria-expanded=\"true\" aria-controls=\"ub-content-toggle-panel-11-b15fc96f-300c-48ab-a45f-00efc2d41171\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-b15fc96f-300c-48ab-a45f-00efc2d41171\"> 12.Di\u011fer <\/h3><\/div><div id=\"ub-content-toggle-panel-11-b15fc96f-300c-48ab-a45f-00efc2d41171\" class=\"wp-block-ub-content-toggle-accordion-content-wrap\" role=\"region\"><ul style=\"list-style-type: circle;\"><li> <a href=\"https:\/\/exceladvisor.org\/tr\/giris-alani\/\">VBA&#8217;da giri\u015f kutusu nas\u0131l kullan\u0131l\u0131r?<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/\">VBA bir metin dosyas\u0131 olu\u015fturma ve yazma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ekran-guncellemesi\/\">VBA Ekran G\u00fcncellemesi | Nas\u0131l etkinle\u015ftirilir ve devre d\u0131\u015f\u0131 b\u0131rak\u0131l\u0131r<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/durum-cubugu-1\/\">VBA durum \u00e7ubu\u011fu (gizle, g\u00f6ster ve ilerleme)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/uyumayi-bekle\/\">Ask\u0131ya almak ve geciktirmek i\u00e7in VBA bekleme ve uyku komutlar\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-1\/\" data-wpil=\"url\">VBA \u2013 MAKRO KODU Kullanarak Excel&#8217;de PivotTable Olu\u015fturmak \u0130\u00e7in Ad\u0131m Ad\u0131m K\u0131lavuz<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/google-arama\/\" data-wpil=\"url\">VBA kodunu kullanarak Google&#8217;da nas\u0131l arama yap\u0131l\u0131r?<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/\">Excel&#8217;de onay kutusu nas\u0131l eklenir<\/a><\/li><\/ul><\/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-1492","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 nedir? (Temelden \u0130leri D\u00fczey 2023&#039;e)<\/title>\n<meta name=\"description\" content=\"Bu, Excel&#039;de VBA&#039;y\u0131 \u00f6\u011frenmek i\u00e7in eksiksiz bir e\u011fitimdir. Bu sayfada onu en iyi hale getiren 100&#039;den fazla \u00f6\u011fretici bulacaks\u0131n\u0131z\" \/>\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\/vba\/\" \/>\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 nedir? (Temelden \u0130leri D\u00fczey 2023&#039;e)\" \/>\n<meta property=\"og:description\" content=\"Bu, Excel&#039;de VBA&#039;y\u0131 \u00f6\u011frenmek i\u00e7in eksiksiz bir e\u011fitimdir. Bu sayfada onu en iyi hale getiren 100&#039;den fazla \u00f6\u011fretici bulacaks\u0131n\u0131z\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:03:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Code-de-macro-a-utiliser-VBA-pour-creer-un-tableau-croise-dynamique-dans-Excel.gif\" \/>\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=\"18 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/vba\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/vba\/\",\"name\":\"\u25b7 Excel&#39;de VBA nedir? (Temelden \u0130leri D\u00fczey 2023&#39;e)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/vba\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Code-de-macro-a-utiliser-VBA-pour-creer-un-tableau-croise-dynamique-dans-Excel.gif\",\"datePublished\":\"2023-11-21T04:27:53+00:00\",\"dateModified\":\"2023-12-10T06:03:00+00:00\",\"description\":\"Bu, Excel&#39;de VBA&#39;y\u0131 \u00f6\u011frenmek i\u00e7in eksiksiz bir e\u011fitimdir. Bu sayfada onu en iyi hale getiren 100&#39;den fazla \u00f6\u011fretici bulacaks\u0131n\u0131z\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/vba\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/vba\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/vba\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Code-de-macro-a-utiliser-VBA-pour-creer-un-tableau-croise-dynamique-dans-Excel.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Code-de-macro-a-utiliser-VBA-pour-creer-un-tableau-croise-dynamique-dans-Excel.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de vba nedir? (temelden i\u0307leri d\u00fczey&#39;e)\"}]},{\"@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 nedir? (Temelden \u0130leri D\u00fczey 2023&#39;e)","description":"Bu, Excel&#39;de VBA&#39;y\u0131 \u00f6\u011frenmek i\u00e7in eksiksiz bir e\u011fitimdir. Bu sayfada onu en iyi hale getiren 100&#39;den fazla \u00f6\u011fretici bulacaks\u0131n\u0131z","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\/vba\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Excel&#39;de VBA nedir? (Temelden \u0130leri D\u00fczey 2023&#39;e)","og_description":"Bu, Excel&#39;de VBA&#39;y\u0131 \u00f6\u011frenmek i\u00e7in eksiksiz bir e\u011fitimdir. Bu sayfada onu en iyi hale getiren 100&#39;den fazla \u00f6\u011fretici bulacaks\u0131n\u0131z","og_url":"https:\/\/exceladvisor.org\/tr\/vba\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:03:00+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Code-de-macro-a-utiliser-VBA-pour-creer-un-tableau-croise-dynamique-dans-Excel.gif","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"18 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/vba\/","url":"https:\/\/exceladvisor.org\/tr\/vba\/","name":"\u25b7 Excel&#39;de VBA nedir? (Temelden \u0130leri D\u00fczey 2023&#39;e)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/vba\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/vba\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Code-de-macro-a-utiliser-VBA-pour-creer-un-tableau-croise-dynamique-dans-Excel.gif","datePublished":"2023-11-21T04:27:53+00:00","dateModified":"2023-12-10T06:03:00+00:00","description":"Bu, Excel&#39;de VBA&#39;y\u0131 \u00f6\u011frenmek i\u00e7in eksiksiz bir e\u011fitimdir. Bu sayfada onu en iyi hale getiren 100&#39;den fazla \u00f6\u011fretici bulacaks\u0131n\u0131z","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/vba\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/vba\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/vba\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Code-de-macro-a-utiliser-VBA-pour-creer-un-tableau-croise-dynamique-dans-Excel.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Code-de-macro-a-utiliser-VBA-pour-creer-un-tableau-croise-dynamique-dans-Excel.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de vba nedir? (temelden i\u0307leri d\u00fczey&#39;e)"}]},{"@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\/1492","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=1492"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1492\/revisions"}],"predecessor-version":[{"id":2629,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1492\/revisions\/2629"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}