{"id":1511,"date":"2023-11-18T20:22:47","date_gmt":"2023-11-18T20:22:47","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/"},"modified":"2023-12-10T06:08:03","modified_gmt":"2023-12-10T06:08:03","slug":"temel-gorsel-duzenleyici","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/","title":{"rendered":"Windows ve mac i\u00e7in excel visual basic d\u00fczenleyicisi"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1326112186\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p class=\"wp-block-heading\"><strong>ANAHTAR NOKTALARI<\/strong><\/p><ul><li> Visual Basic Editor, VBA i\u00e7in bir kod d\u00fczenleyicisidir.<\/li><li> Bu ayr\u0131 bir uygulamad\u0131r ancak yaln\u0131zca Excel ile kullanabilirsiniz.<\/li><li> Eri\u015fmek i\u00e7in \u015feritte <a href=\"https:\/\/exceladvisor.org\/tr\/gelistirici-sekmesi-ekle\/\">Geli\u015ftirici sekmesinin<\/a> olmas\u0131 gerekir.<\/li><li> Ayr\u0131ca <a href=\"https:\/\/exceladvisor.org\/tr\/klavye-kisayollari\/\">klavye k\u0131sayolunu<\/a> da kullanabilirsiniz (Alt + F11).<\/li><li> Ayr\u0131ca makro kaydediciyle yeniden kodlad\u0131\u011f\u0131n\u0131z makrolar\u0131 da saklar.<\/li><li> T\u00fcm kodlar\u0131 yazman\u0131za ve y\u00f6netmenize yard\u0131mc\u0131 olacak \u00e7e\u015fitli ara\u00e7lara sahiptir.<\/li><\/ul><p> VBA d\u00fcnyas\u0131 Visual Basic D\u00fczenleyicisi (VBE) ile ba\u015flar.<\/p><p> Buras\u0131 t\u00fcm makro kodlar\u0131 yazd\u0131\u011f\u0131n\u0131z ve y\u00f6netti\u011finiz yerdir ve bana VBE&#8217;yi sorarsan\u0131z \u015funu s\u00f6yleyebilirim ki, e\u011fer ger\u00e7ekten VBA \u00f6\u011frenmek istiyorsan\u0131z VBE&#8217;nin t\u00fcm bile\u015fenlerini anlaman\u0131z gerekir.<\/p><p> Bu nedenle bu, <a href=\"https:\/\/exceladvisor.org\/tr\/vba\/\">VBA e\u011fitimimizin<\/a> bir par\u00e7as\u0131d\u0131r ve bu k\u0131lavuzda, \u00f6zelliklerini anlaman\u0131z\u0131 sa\u011flamak i\u00e7in Visual Basic D\u00fczenleyicisi&#8217;nin t\u00fcm y\u00f6nlerini ele ald\u0131k.<\/p><p> \u00d6yleyse ba\u015flayal\u0131m.<\/p><p class=\"content-box-green\"> Bu k\u0131lavuzda Visual Basic D\u00fczenleyicisi&#8217;ne at\u0131fta bulunmak i\u00e7in farkl\u0131 kelimeler (VBA d\u00fczenleyicisi, VB d\u00fczenleyicisi veya VBE) kullanaca\u011f\u0131m, bu y\u00fczden kafan\u0131z kar\u0131\u015fmas\u0131n.<\/p><h2 class=\"wp-block-heading\"> Visual Basic D\u00fczenleyicisi nedir?<\/h2><p> Visual Basic Editor, t\u00fcm VBA kodlar\u0131n\u0131 yaz\u0131p kaydedebilece\u011finiz (ayr\u0131) bir uygulamad\u0131r. Basit bir ifadeyle, t\u00fcm makrolar\u0131 yazabilece\u011finiz ve saklayabilece\u011finiz Excel i\u00e7in bir kod d\u00fczenleyicisidir. Ayr\u0131 bir uygulama (VB Edit\u00f6r) olmas\u0131na ra\u011fmen sadece Excel ile kullanabilirsiniz.<\/p><p> Evet bu do\u011fru. VBE&#8217;yi ayr\u0131 olarak \u00e7al\u0131\u015ft\u0131ramazs\u0131n\u0131z; VBE&#8217;yi kullanmak i\u00e7in bir Excel \u00e7al\u0131\u015fma kitab\u0131n\u0131n a\u00e7\u0131k olmas\u0131 gerekir.<\/p><p> Visual Basic D\u00fczenleyicisi, Excel&#8217;de VBA kodu yazman\u0131n tek yoludur. Asl\u0131nda, VBA&#8217;y\u0131 bar\u0131nd\u0131ran t\u00fcm Microsoft uygulamalar\u0131, komut dosyas\u0131 olu\u015fturma (kod yazma) i\u00e7in Visual Basic D\u00fczenleyicisi&#8217;ni kullan\u0131r.<\/p><p> VBE a\u015fa\u011f\u0131dad\u0131r:<\/p><p> <strong>Microsoft Windows<\/strong> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49092\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-vbe.png\" sizes=\"auto, \" srcset=\"\" alt=\"vbe penceresi\" width=\"1934\" height=\"1094\"><\/figure><\/div><p> <strong>Mac<\/strong> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49378\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/editeur-visuel-basique-mac.png\" sizes=\"auto, \" srcset=\"\" alt=\"g\u00f6rsel-temel-d\u00fczenleyici-mac\" width=\"1449\" height=\"902\"><\/figure><\/div><p class=\"content-box-blue\"> VBA, <a href=\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/\"><strong>GEL\u0130\u015eM\u0130\u015e EXCEL BECER\u0130LER\u0130NDEN<\/strong><\/a> biridir ve VBA&#8217;da ustala\u015fmak i\u00e7in; Visual Basic D\u00fczenleyicinin t\u00fcm y\u00f6nlerini \u00f6\u011frenmelisiniz.<\/p><h2 class=\"wp-block-heading\"> Visual Basic D\u00fczenleyicisini a\u00e7\u0131n<\/h2><h3 class=\"wp-block-heading\"> Geli\u015ftirici sekmesinden<\/h3><p> Visual Basic D\u00fczenleyicisini a\u00e7mak i\u00e7in \u015eeritte Geli\u015ftirici sekmesine sahip olman\u0131z ve Geli\u015ftirici sekmesini etkinle\u015ftirmeniz gerekir ( <a href=\"https:\/\/exceladvisor.org\/tr\/gelistirici-sekmesi-ekle\/\" rel=\"nofollow\">ekleme ad\u0131mlar\u0131<\/a> ). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49093\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-onglet-developpeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"geli\u015ftirici sekmesi\" width=\"1242\" height=\"206\"><\/figure><\/div><p> Art\u0131k geli\u015ftirici sekmesinde kod grubunda <strong>&#8220;Visual Basic&#8221; ad\u0131nda bir buton<\/strong> var ve bu butona t\u0131klad\u0131\u011f\u0131n\u0131zda VB edit\u00f6r\u00fcn\u00fc a\u00e7\u0131yor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49094\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-bouton-de-base-visuel.png\" sizes=\"auto, \" srcset=\"\" alt=\"temel g\u00f6rsel d\u00fc\u011fme\" width=\"319\" height=\"132\"><\/figure><\/div><h3 class=\"wp-block-heading\"> K\u0131sayol tu\u015fu (pencere)<\/h3><p> Ayr\u0131ca Windows&#8217;ta VBE&#8217;yi a\u00e7mak i\u00e7in <strong>Alt + F11<\/strong> klavye k\u0131sayol tu\u015funu ve MAC i\u00e7in <strong>Opt + F11<\/strong> veya Fn + Opt + F11 tu\u015flar\u0131n\u0131 da kullanabilirsiniz.<\/p><p> \u015eeritte geli\u015ftirici sekmeniz olmasa bile bu k\u0131sayol tu\u015fu \u00e7al\u0131\u015fmaya devam edecek ve d\u00fczenleyiciyi a\u00e7acakt\u0131r.<\/p><h3 class=\"wp-block-heading\"> Listeden bir makroyu d\u00fczenleme<\/h3><p> Belirli bir makroyu d\u00fczenlemek i\u00e7in VBA d\u00fczenleyicisini a\u00e7mak istiyorsan\u0131z geli\u015ftirici sekmesinden makro listesini a\u00e7abilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49095\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-modifier-une-macro-de-la-liste.png\" sizes=\"auto, \" srcset=\"\" alt=\"listenin bir makrosunu de\u011fi\u015ftir\" width=\"316\" height=\"133\"><\/figure><\/div><p> Ve bu belirli makroyu d\u00fczenlemek \u00fczere VB d\u00fczenleyicisini a\u00e7mak i\u00e7in d\u00fczenle d\u00fc\u011fmesine t\u0131klay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49096\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-bouton-dedition-pour-ouvrir-lediteur-vb.png\" sizes=\"auto, \" srcset=\"\" alt=\"vb-d\u00fczenleyiciyi-a\u00e7mak i\u00e7in d\u00fczenleme d\u00fc\u011fmesi\" width=\"486\" height=\"275\"><\/figure><\/div><h3 class=\"wp-block-heading\"> H\u0131zl\u0131 Eri\u015fim Ara\u00e7 \u00c7ubu\u011funda<\/h3><p> VBA d\u00fczenleyicisini a\u00e7mak i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/hizli-erisim-cubugu\/\">H\u0131zl\u0131 Eri\u015fim Ara\u00e7 \u00c7ubu\u011funa<\/a> bir d\u00fc\u011fme de ekleyebilirsiniz. Bunun i\u00e7in H\u0131zl\u0131 Eri\u015fim Ara\u00e7 \u00c7ubu\u011fundaki a\u00e7\u0131l\u0131r men\u00fcye t\u0131klay\u0131p di\u011fer komutlar\u0131 a\u00e7man\u0131z gerekmektedir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49097\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-barre-doutils-dacces-rapide.png\" sizes=\"auto, \" srcset=\"\" alt=\"h\u0131zl\u0131 eri\u015fim \u00e7ubu\u011fu\" width=\"522\" height=\"523\"><\/figure><\/div><p> Daha sonra \u201cKomutlar\u0131 se\u00e7\u201d b\u00f6l\u00fcm\u00fcnde geli\u015ftirici sekmesini se\u00e7in ve ard\u0131ndan Ekle d\u00fc\u011fmesine t\u0131klayarak temel g\u00f6rsel d\u00fczenleyiciyi H\u0131zl\u0131 Eri\u015fim Ara\u00e7 \u00c7ubu\u011funa ekleyin. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49098\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-onglet-developpeur-a-partir-de-choisir-des-commandes.png\" sizes=\"auto, \" srcset=\"\" alt=\"geli\u015ftirici-sekme-se\u00e7im-komutlar\u0131\" width=\"587\" height=\"339\"><\/figure><\/div><p> Art\u0131k Visual Basic d\u00fczenleyicisini QAT \u00fczerindeki d\u00fc\u011fmeden a\u00e7abilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49099\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-barre-doutils-dacces-rapide.png\" sizes=\"auto, \" srcset=\"\" alt=\"h\u0131zl\u0131 eri\u015fim \u00e7ubu\u011fu\" width=\"411\" height=\"158\"><\/figure><\/div><h3 class=\"wp-block-heading\"> E-tablo sekmesinden<\/h3><p> VBA d\u00fczenleyicisini, \u00e7al\u0131\u015fma sayfas\u0131 sekmesine sa\u011f t\u0131klay\u0131p ekran koduna t\u0131klayarak da a\u00e7abilirsiniz. Bu sizi an\u0131nda bu \u00e7al\u0131\u015fma sayfas\u0131n\u0131n kod penceresine g\u00f6t\u00fcrecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49100\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-onglet-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"elektronik tablo sekmesi\" width=\"236\" height=\"345\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Visual Basic D\u00fczenleyici Bile\u015fenleri<\/h2><p> VBA d\u00fczenleyicisini ilk a\u00e7t\u0131\u011f\u0131n\u0131zda eski bir uygulama gibi g\u00f6r\u00fcn\u00fcr ve nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 anlamak i\u00e7in bile\u015fen bile\u015fen gitmeniz gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49204\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/composants-editeur-de-base-visuel-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"bile\u015fenler-g\u00f6rsel-temel-d\u00fczenleyici\" width=\"1934\" height=\"1094\"><\/figure><\/div><p> Kullan\u0131c\u0131 aray\u00fcz\u00fc 15 y\u0131l\u0131 a\u015fk\u0131n bir s\u00fcredir Excel&#8217;in t\u00fcm s\u00fcr\u00fcmleri i\u00e7in (neredeyse) ayn\u0131 olmu\u015ftur; bu nedenle, hangi Excel s\u00fcr\u00fcm\u00fcn\u00fc kullan\u0131yor olursan\u0131z olun, bu k\u0131lavuzdan Visual Basic D\u00fczenleyicisi hakk\u0131nda daha fazla bilgi edinebilirsiniz. Evet, VBE&#8217;nin size farkl\u0131 \u015fekillerde yard\u0131mc\u0131 olabilecek farkl\u0131 bile\u015fenleri vard\u0131r; hadi bunlar\u0131 tek tek inceleyelim.<\/p><ol><li> Ara\u00e7 \u00c7ubu\u011fu<\/li><li> Ara\u00e7 \u00c7ubu\u011fu<\/li><li> Proje penceresi<\/li><li> \u00d6zellikler penceresi<\/li><li> Pencere kodlar\u0131<\/li><li> An\u0131nda pencere<\/li><li> \u0130zleme penceresi<\/li><li> Nesne Taray\u0131c\u0131<\/li><li> Bul ve De\u011fi\u015ftir<\/li><li> Yerel pencere<\/li><\/ol><h3 class=\"wp-block-heading\"> 1. \u00c7ubuk men\u00fcs\u00fc<\/h3><p> Di\u011fer uygulamalar gibi VBA d\u00fczenleyicisinde de kullan\u0131c\u0131ya sunulan t\u00fcm se\u00e7enekleri bulabilece\u011finiz bir men\u00fc \u00e7ubu\u011fu bulunur. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49101\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-menus-de-lediteur-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-d\u00fczenleyici-men\u00fcs\u00fc\" width=\"625\" height=\"42\"><\/figure><\/div><p> Art\u0131k men\u00fc \u00e7ubu\u011funda her sekme mevcut se\u00e7eneklerin bir kategorisidir. Diyelim ki d\u00fczenleme men\u00fcs\u00fcnde kes-kopyala-yap\u0131\u015ft\u0131r, bul ve de\u011fi\u015ftir, girinti ve a\u015fa\u011f\u0131 girinti ekleme se\u00e7eneklerini g\u00f6rebiliyorsunuz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49102\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-options-donglets-de-la-barre-de-menus.png\" sizes=\"auto, \" srcset=\"\" alt=\"men\u00fc \u00e7ubu\u011fu sekme se\u00e7enekleri\" width=\"279\" height=\"527\"><\/figure><\/div><p> T\u00fcm se\u00e7eneklerle (\u00e7o\u011fu), bu se\u00e7enekleri kullanmak i\u00e7in k\u0131sayol tu\u015flar\u0131n\u0131 bulabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> 2. Ara\u00e7 \u00c7ubu\u011fu<\/h3><p> Men\u00fc \u00e7ubu\u011funun hemen alt\u0131nda, normal bir kullan\u0131c\u0131n\u0131n daha s\u0131k kullanmas\u0131 gereken baz\u0131 se\u00e7eneklerin bir koleksiyonu olan ara\u00e7 \u00e7ubu\u011fu bulunur. Visual Basic edit\u00f6r\u00fcn\u00fc ilk a\u00e7t\u0131\u011f\u0131n\u0131zda t\u0131pk\u0131 a\u015fa\u011f\u0131daki g\u00f6rseldeki gibi sadece standart ara\u00e7 \u00e7ubu\u011funa sahip olacaks\u0131n\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49103\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-barre-doutils.png\" sizes=\"auto, \" srcset=\"\" alt=\"ara\u00e7 \u00e7ubu\u011fu\" width=\"644\" height=\"73\"><\/figure><\/div><p> Ancak ekleyebilece\u011finiz ve kullanabilece\u011finiz toplam d\u00f6rt ara\u00e7 \u00e7ubu\u011fu vard\u0131r.<\/p><ol><li> Hata ay\u0131klama<\/li><li> D\u00fczenlemek<\/li><li> Standart<\/li><li> Kullan\u0131c\u0131 formu<\/li><\/ol><p> Men\u00fc \u00e7ubu\u011fundaki G\u00f6r\u00fcn\u00fcm sekmesine giderseniz bu ara\u00e7 \u00e7ubuklar\u0131n\u0131 ekleme veya kald\u0131rma se\u00e7ene\u011finiz vard\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49104\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-options-donglet-de-la-barre-doutils.png\" sizes=\"auto, \" srcset=\"\" alt=\"ara\u00e7 \u00e7ubu\u011fu sekmesi se\u00e7enekleri\" width=\"380\" height=\"468\"><\/figure><\/div><p> Ayr\u0131ca isterseniz ara\u00e7 \u00e7ubu\u011funa d\u00fc\u011fmeler ekleyebilir veya kald\u0131rabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49105\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-ajouter-ou-supprimer-des-boutons-de-la-barre-doutils.png\" sizes=\"auto, \" srcset=\"\" alt=\"ara\u00e7 \u00e7ubu\u011fu d\u00fc\u011fmelerini ekleme veya kald\u0131rma\" width=\"536\" height=\"469\"><\/figure><\/div><p> Ayr\u0131ca sa\u011f taraftaki k\u00fc\u00e7\u00fck noktalar\u0131 s\u00fcr\u00fckleyip b\u0131rakarak da bir ara\u00e7 \u00e7ubu\u011funu ta\u015f\u0131yabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49106\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-glisser-deposer-depuis-les-petits-points.png\" sizes=\"auto, \" srcset=\"\" alt=\"k\u00fc\u00e7\u00fck noktalardan-s\u00fcr\u00fckle ve b\u0131rak\" width=\"635\" height=\"54\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 3. Proje Penceresi\/Proje Gezgini<\/h3><p> Proje penceresi mevcut t\u00fcm projeleri g\u00f6rebilece\u011finiz yerdir. Bir dosyay\u0131 a\u00e7t\u0131\u011f\u0131n\u0131zda ve ard\u0131ndan Visual Basic D\u00fczenleyicisini a\u00e7t\u0131\u011f\u0131n\u0131zda, o dosyan\u0131n hiyerar\u015fisini Proje penceresinde g\u00f6rebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49107\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-fenetre-de-projet.png\" sizes=\"auto, \" srcset=\"\" alt=\"proje penceresi\" width=\"326\" height=\"176\"><\/figure><\/div><p> Her projenin ayr\u0131ca bir nesne koleksiyonu vard\u0131r:<\/p><ul><li> <strong>\u00c7al\u0131\u015fma Sayfas\u0131<\/strong> : Bir \u00e7al\u0131\u015fma kitab\u0131ndaki her \u00e7al\u0131\u015fma sayfas\u0131 bir nesne olarak listelenir.<\/li><li> <strong>\u00c7al\u0131\u015fma kitab\u0131<\/strong> : \u00c7al\u0131\u015fma kitab\u0131n\u0131n kendisini bir nesne olarak temsil eder.<\/li><li> <strong>Mod\u00fcl<\/strong> : Buras\u0131 kod yazd\u0131\u011f\u0131n\u0131z veya kay\u0131tl\u0131 makrolar\u0131 saklad\u0131\u011f\u0131n\u0131z yerdir.<\/li><li> <strong>Grafik Sayfas\u0131<\/strong> : \u00c7al\u0131\u015fma kitab\u0131n\u0131n grafik sayfas\u0131 da burada listelenecektir. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49108\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-collections-dobjets.png\" sizes=\"auto, \" srcset=\"\" alt=\"nesnelerin toplanmas\u0131\" width=\"475\" height=\"368\"><\/figure><\/div><p> VB edit\u00f6r\u00fcn\u00fc a\u00e7t\u0131\u011f\u0131n\u0131zda, orada varsay\u0131lan proje penceresini bulacaks\u0131n\u0131z. Ancak bir \u015fekilde orada de\u011filse, onu g\u00f6r\u00fcn\u00fcmden (men\u00fc \u00e7ubu\u011fu) ekleyebilir veya Control + R k\u0131sayol tu\u015funu kullanabilirsiniz.<\/p><p> Proje penceresinde listelenen her nesnenin, \u00e7ift t\u0131klayarak veya sa\u011f t\u0131klay\u0131p Kodu G\u00f6ster se\u00e7ene\u011fini se\u00e7erek a\u00e7abilece\u011finiz kendi kod penceresi vard\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49109\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/18-selectionner-le-code-de-vue.png\" sizes=\"auto, \" srcset=\"\" alt=\"g\u00f6r\u00fcn\u00fcm kodunu se\u00e7\" width=\"374\" height=\"211\"><\/figure><\/div><p> Proje penceresi mevcut t\u00fcm projelerde gezinmenin en iyi yoludur ve edit\u00f6rle \u00e7al\u0131\u015fmaya ba\u015flad\u0131\u011f\u0131n\u0131zda onun hakk\u0131nda daha fazla bilgi edineceksiniz.<\/p><h3 class=\"wp-block-heading\"> 4. \u00d6zellikler penceresi<\/h3><p> Ad\u0131ndan da anla\u015f\u0131laca\u011f\u0131 gibi, \u00f6zellikler penceresi se\u00e7ilen nesnenin \u00f6zelliklerine eri\u015fmenizi sa\u011flar. Her nesnenin, \u00f6rne\u011fin bir e-tablonun, g\u00f6r\u00fcnt\u00fcleyebilece\u011finiz ve de\u011fi\u015fiklik yapabilece\u011finiz kendi \u00f6zellikleri vard\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49110\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/19-proprietes-fenetre.png\" sizes=\"auto, \" srcset=\"\" alt=\"pencere \u00f6zellikleri\" width=\"301\" height=\"447\"><\/figure><\/div><p> Her \u00f6zellik i\u00e7in, sa\u011f tarafta o \u00f6zelli\u011fi de\u011fi\u015ftirebilece\u011finiz veya d\u00fczenleyebilece\u011finiz bir a\u00e7\u0131l\u0131r liste bulunur. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49111\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Liste-deroulante-de-20-proprietes.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00f6zellik a\u00e7\u0131l\u0131r listesi\" width=\"428\" height=\"404\"><\/figure><\/div><p class=\"qt-tip\"> <strong>K\u00fc\u00e7\u00fck ipucu:<\/strong> Bir projenin ad\u0131n\u0131 \u00f6zellikler penceresinden de\u011fi\u015ftirebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49112\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/21-changer-le-nom-dun-projet.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir projenin-ad\u0131n\u0131-de\u011fi\u015ftirmek\" width=\"452\" height=\"180\"><\/figure><\/div><p> Ayr\u0131ca, \u00f6zellikler penceresi varsay\u0131lan olarak orada de\u011filse, onu g\u00f6r\u00fcn\u00fcmden (men\u00fc \u00e7ubu\u011fu) etkinle\u015ftirebilir veya F4 k\u0131sayol tu\u015funu da kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49113\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/22-touche-de-raccourci-f4.png\" sizes=\"auto, \" srcset=\"\" alt=\"k\u0131sayol-f4-tu\u015fu\" width=\"252\" height=\"440\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 5. Kod penceresi<\/h3><p> Kod penceresi, kodlar\u0131 yazd\u0131\u011f\u0131n\u0131z ve i\u015finizin \u00e7o\u011funu (d\u00fczenleme, yazma ve test etme) yapt\u0131\u011f\u0131n\u0131z yerdir. Basit\u00e7e s\u00f6ylemek gerekirse, kod penceresi t\u00fcm programlamay\u0131 yapt\u0131\u011f\u0131n\u0131z yerdir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49114\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/fenetre-de-23-codes.png\" sizes=\"auto, \" srcset=\"\" alt=\"kod penceresi\" width=\"1414\" height=\"806\"><\/figure><\/div><p> \u0130lk g\u00f6rd\u00fc\u011f\u00fcn\u00fczde basit bir metin edit\u00f6r\u00fcne benziyor ancak programlama yaparken size yard\u0131mc\u0131 olabilecek <strong>Intellisense<\/strong> \u00f6zelli\u011fine sahip.<\/p><p> Di\u011fer kod edit\u00f6rlerinin yapt\u0131\u011f\u0131 gibi kod penceresine sat\u0131r numaras\u0131 eklemenin bir yolunu bulamad\u0131m, ancak VB edit\u00f6r\u00fc her zaman kodun sat\u0131r numaras\u0131n\u0131 g\u00f6steriyor. <\/p><div id=\"\" class=\"su-box su-box-style-default\" style=\"border-color: #169f62; border-radius: 2px;\"><div class=\"su-box-title\" style=\"background-color: #49d295; color: #000000; border-top-left-radius: 0px; border-top-right-radius: 0px;\"> Not <\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius: 0px; border-bottom-right-radius: 0px;\"> Di\u011fer kod edit\u00f6rlerinin yapt\u0131\u011f\u0131 gibi kod penceresine sat\u0131r numaras\u0131 eklemenin bir yolunu bulamad\u0131m, ancak VB edit\u00f6r\u00fc size kodun sat\u0131r numaras\u0131n\u0131 hala s\u00f6yl\u00fcyor.<\/div><\/div><h3 class=\"wp-block-heading\"> 6. An\u0131nda pencere<\/h3><p> Hemen pencere, kodunuzda hata ay\u0131klayabilece\u011finiz yerdir. Bir kod sat\u0131r\u0131 yaz\u0131p nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 test edebilirsiniz. Diyelim ki a\u015fa\u011f\u0131daki kodu test etmek istiyorsunuz:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").Value = 9999<\/code><\/pre><p> Tek yapman\u0131z gereken girmek, bir soru i\u015fareti yaz\u0131p kodu buraya yap\u0131\u015ft\u0131rmak ve Enter tu\u015funa basmak. Hemen kod sonucunu g\u00f6sterecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49117\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/26-fenetre-immediate.png\" sizes=\"auto, \" srcset=\"\" alt=\"acil pencere\" width=\"360\" height=\"162\"><\/figure><\/div><p> Di\u011fer y\u00f6ntem ise kodun \u00f6n\u00fcne Debug.Print eklemek ve sonu\u00e7 de\u011ferini hemen pencerede almakt\u0131r. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub Macro1() Debug.Print Range(\"A1\").Value = \"Yes\" End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49118\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/27-ajouter-une-impression-de-debogage.png\" sizes=\"auto, \" srcset=\"\" alt=\"ekleme-hata ay\u0131klama-yazd\u0131rma\" width=\"399\" height=\"341\"><\/figure><\/div><p> Varsay\u0131lan olarak, Visual Basic d\u00fczenleyicisini a\u00e7t\u0131\u011f\u0131n\u0131zda hemen pencere orada olmayacakt\u0131r, bu nedenle onu men\u00fc \u00e7ubu\u011funun G\u00f6r\u00fcn\u00fcm sekmesinden etkinle\u015ftirmeniz gerekir. Control + G k\u0131sayol tu\u015funu da kullanabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> 7. \u0130zleme penceresi<\/h3><p> T\u0131pk\u0131 <a href=\"https:\/\/exceladvisor.org\/tr\/pencereyi-izle\/\">Excel \u0130zleme Penceresi<\/a> gibi, Visual Basic D\u00fczenleyicisi&#8217;nde de onlar\u0131 izlemek i\u00e7in ifadeler ekleyebilece\u011finiz bir izleme penceresi bulunur. Basit\u00e7e ifadeyi se\u00e7in, ard\u0131ndan sa\u011f t\u0131klay\u0131n ve bir saat ekleyin. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49143\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/51-fenetre-de-montre.png\" sizes=\"auto, \" srcset=\"\" alt=\"pencereyi izle\" width=\"178\" height=\"315\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte, Append watch&#8217;a Selection.Value&#8217;yu ekledim. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49144\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/52-a-ajoute-la-valeur-de-selection_.png\" sizes=\"auto, \" srcset=\"\" alt=\"52-se\u00e7ime-de\u011fer eklendi_\" width=\"501\" height=\"263\"><\/figure><\/div><p> \u015eimdi izleme penceresini etkinle\u015ftirmek i\u00e7in G\u00f6r\u00fcn\u00fcm men\u00fcs\u00fcne gidin ve izleme penceresi se\u00e7ene\u011fine t\u0131klay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49145\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/53-loption-de-fenetre-de-surveillance.png\" sizes=\"auto, \" srcset=\"\" alt=\"53-izleme penceresi se\u00e7ene\u011fi\" width=\"243\" height=\"427\"><\/figure><\/div><p> Ve burada eklenen ifadeyi takip eden izleme penceresine sahipsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49146\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/54-suivi-de-la-fenetre-de-surveillance.png\" sizes=\"auto, \" srcset=\"\" alt=\"54 izleme penceresi izleme\" width=\"629\" height=\"151\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 8. Nesne Gezgini<\/h3><p> VBA&#8217;n\u0131n, kullanabilece\u011finiz t\u00fcm \u00f6zellikleri bularak t\u00fcm nesnelerle \u00e7al\u0131\u015fman\u0131za yard\u0131mc\u0131 olabilecek kendi Nesne Taray\u0131c\u0131s\u0131 vard\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49115\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/navigateur-de-24-objets.png\" sizes=\"auto, \" srcset=\"\" alt=\"nesne taray\u0131c\u0131s\u0131\" width=\"1226\" height=\"688\"><\/figure><\/div><p> Aral\u0131k nesnesini kullanmak istedi\u011finizi hayal edin, nesne taray\u0131c\u0131s\u0131 size onunla birlikte gelen t\u00fcm \u00f6zellikleri ve y\u00f6ntemleri g\u00f6sterecektir. A\u015fa\u011f\u0131daki \u00f6rne\u011fe bak\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49116\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Navigateur-dobjets-a-25-plages.png\" sizes=\"auto, \" srcset=\"\" alt=\"aral\u0131k-nesne-taray\u0131c\u0131\" width=\"350\" height=\"406\"><\/figure><\/div><p> Nesne Taray\u0131c\u0131s\u0131n\u0131 a\u00e7mak i\u00e7in <strong>F2<\/strong> k\u0131sayol tu\u015funu kullan\u0131n veya G\u00f6r\u00fcn\u00fcm sekmesine gidip Nesne Taray\u0131c\u0131y\u0131 t\u0131klatarak da a\u00e7abilirsiniz.<\/p><h3 class=\"wp-block-heading\"> 9. Bul ve De\u011fi\u015ftir<\/h3><p> T\u0131pk\u0131 Excel&#8217;deki bul ve de\u011fi\u015ftir gibi, VBA d\u00fczenleyicisinin de prosed\u00fcrlerdeki de\u011ferleri bulmak ve de\u011fi\u015ftirmek i\u00e7in kullanabilece\u011finiz kendi bul ve de\u011fi\u015ftir se\u00e7ene\u011fi vard\u0131r. BUL se\u00e7ene\u011fini a\u00e7mak i\u00e7in Control + F k\u0131sayol tu\u015funu, de\u011fi\u015ftirmeyi a\u00e7mak i\u00e7in ise Control + H k\u0131sayol tu\u015funu kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49133\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/41-code-actif-visible.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"405\" height=\"228\"><\/figure><\/div><p> Aksi halde d\u00fczenleme men\u00fcs\u00fcnden her iki se\u00e7ene\u011fi de a\u00e7abilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49137\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/45-rechercher-et-remplacer.png\" sizes=\"auto, \" srcset=\"\" alt=\"bul ve De\u011fi\u015ftir\" width=\"428\" height=\"220\"><\/figure><\/div><p> VBE&#8217;deki Bul ve De\u011fi\u015ftir se\u00e7ene\u011fi size farkl\u0131 arama modelleri sunar; \u00f6rne\u011fin mevcut prosed\u00fcrde, mevcut mod\u00fclde veya mevcut projede bir \u015feyi bulup de\u011fi\u015ftirmek istiyorsan\u0131z.<\/p><p> Ayr\u0131ca B\u00dcY\u00dcK HARF DUYARLI aramay\u0131 kullanabilir ve arama y\u00f6n\u00fcne de karar verebilirsiniz.<\/p><h3 class=\"wp-block-heading\"> 10. Yerel Pencere<\/h3><p> Ge\u00e7erli prosed\u00fcrde bildirilen t\u00fcm de\u011fi\u015fkenleri ve bunlar\u0131n ge\u00e7erli de\u011ferlerini g\u00f6r\u00fcnt\u00fclemek i\u00e7in VBE&#8217;deki Yerel De\u011fi\u015fkenler penceresini kullanabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Kod yazmak i\u00e7in VB D\u00fczenleyiciyi kullan\u0131n<\/h2><p> Bu noktada VBA edit\u00f6r\u00fcn\u00fcn t\u00fcm ana bile\u015fenlerini biliyorsunuz, \u015fimdi ona nas\u0131l kod ekleyece\u011fimizi \u00f6\u011frenelim.<\/p><h3 class=\"wp-block-heading\"> Mod\u00fcl kodu penceresi ve nesne kodu penceresi<\/h3><p> \u0130ki farkl\u0131 t\u00fcrde Windows kodu vard\u0131r ve her ikisi de benzer g\u00f6r\u00fcn\u00fcr, ancak bilmeniz gereken bir fark vard\u0131r.<\/p><ol><li> <strong>Mod\u00fcl Kodu Penceresi<\/strong> : Normal mod\u00fcl kodunu manuel olarak \u00e7al\u0131\u015ft\u0131rabilece\u011finiz gibi ayr\u0131 bir prosed\u00fcrden de \u00e7a\u011f\u0131rabilirsiniz.<\/li><li> <strong>Nesne Kodu Penceresi<\/strong> : Nesne kodu penceresindeki kod bir olay kullan\u0131larak y\u00fcr\u00fct\u00fclebilir. Diyelim ki bir h\u00fccreye \u00e7ift t\u0131klad\u0131\u011f\u0131n\u0131zda bir kod \u00e7al\u0131\u015ft\u0131rmak istiyorsunuz. Bu durumda \u00e7ift t\u0131klama olay\u0131n\u0131 kullanman\u0131z ve bu \u00e7al\u0131\u015fma sayfas\u0131na baz\u0131 kodlar eklemeniz gerekir.<\/li><\/ol><h3 class=\"wp-block-heading\"> 2. Kod penceresi mod\u00fcl\u00fc<\/h3><p> VBA kodunun \u00e7o\u011funu bir mod\u00fcle yazacaks\u0131n\u0131z. Bir mod\u00fcle kod eklemek i\u00e7in SUB prosed\u00fcr\u00fcn\u00fc veya FUNCTION prosed\u00fcr\u00fcn\u00fc kullanman\u0131z gerekir.<\/p><ul><li> Alt prosed\u00fcr<\/li><li> \u0130\u015flev prosed\u00fcr\u00fc<\/li><\/ul><p> Bir alt prosed\u00fcr ile bir fonksiyon prosed\u00fcr\u00fc aras\u0131ndaki fark, alt prosed\u00fcr\u00fcn bir de\u011fer d\u00f6nd\u00fcrememesi, buna kar\u015f\u0131n bir fonksiyon prosed\u00fcr\u00fcn\u00fcn bir de\u011fer d\u00f6nd\u00fcrebilmesidir.<\/p><p class=\"content-box-green\"> <a href=\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/\">Bir makro kaydetti\u011finizde bu kod,<\/a> makro kaydediciyi kulland\u0131\u011f\u0131n\u0131zda VBA&#8217;n\u0131n otomatik olarak ekledi\u011fi bir mod\u00fcle do\u011frudan gider.<\/p><h4 class=\"wp-block-heading\"> Mod\u00fcl ekleme<\/h4><p> Kod yazman\u0131z gerekti\u011finde bir <a href=\"https:\/\/exceladvisor.org\/tr\/modul\/\">mod\u00fcl<\/a> eklemeniz gerekir ve bunun i\u00e7in proje penceresine gidip proje ad\u0131na sa\u011f t\u0131klay\u0131p bu men\u00fcden Ekle&#8217;ye gidip mod\u00fcl\u00fc se\u00e7meniz yeterlidir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49119\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/28-inserer-un-module.png\" sizes=\"auto, \" srcset=\"\" alt=\"mod\u00fcl ekleme\" width=\"399\" height=\"385\"><\/figure><\/div><h4 class=\"wp-block-heading\"> Bir mod\u00fcl\u00fc silme<\/h4><p> Art\u0131k gerekmiyorsa bir mod\u00fcl\u00fc de silebilirsiniz; bu nedenle mod\u00fcle sa\u011f t\u0131klay\u0131n ve Sil&#8217;i se\u00e7in. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49120\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/29-supprimer-un-module.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir mod\u00fcl\u00fc sil\" width=\"372\" height=\"435\"><\/figure><\/div><p> Sil&#8217;e t\u0131klad\u0131\u011f\u0131n\u0131zda, silmeden \u00f6nce bu mod\u00fcl\u00fc kaydetmek isteyip istemedi\u011finiz sorulur. Ayr\u0131ca bir mod\u00fcl\u00fc sisteminize dosya olarak kaydetmek i\u00e7in d\u0131\u015fa aktarma se\u00e7ene\u011fi de vard\u0131r.<\/p><h3 class=\"wp-block-heading\"> 3. Nesne Kodu Penceresi<\/h3><p> Nesnenin kod penceresini a\u00e7mak i\u00e7in \u00fczerine \u00e7ift t\u0131klaman\u0131z yeterlidir ve kod penceresinde, kodu \u00e7al\u0131\u015ft\u0131rmak i\u00e7in kullanmak istedi\u011finiz olay\u0131 se\u00e7ebilece\u011finiz bir a\u00e7\u0131l\u0131r liste bulunur. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49121\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Module-30-objets.png\" sizes=\"auto, \" srcset=\"\" alt=\"mod\u00fcl nesnesi\" width=\"1418\" height=\"455\"><\/figure><\/div><p> Kodu yazmak istiyorsan\u0131z ve \u00e7ift t\u0131klama i\u015flemini ger\u00e7ekle\u015ftirmek istiyorsan\u0131z, a\u00e7\u0131l\u0131r listeden \u201cDoubleClick&#8217;ten \u00d6nce\u201d se\u00e7ene\u011fini se\u00e7meniz gerekti\u011fini d\u00fc\u015f\u00fcn\u00fcn.<\/p><h2 class=\"wp-block-heading\"> Tasar\u0131m moduna, y\u00fcr\u00fctme moduna ve hata ay\u0131klama moduna genel bak\u0131\u015f<\/h2><p> Visual Basic d\u00fczenleyicisini programlaman\u0131n \u015fekline, kod yazma, hata bulma ve hata d\u00fczeltmeye ba\u011fl\u0131 olarak \u00fc\u00e7 farkl\u0131 modda kullanabilirsiniz.<\/p><ul><li> <strong>Tasar\u0131m modu<\/strong> : Normalde VB edit\u00f6r\u00fcnde kod \u00fczerinde \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda tasar\u0131m modundas\u0131n\u0131zd\u0131r. O zaman bile bir kullan\u0131c\u0131 formu veya form tasarlamak yerine sadece kodu yaz\u0131yorsunuz, sanki kod yaz\u0131yormu\u015f gibi tasar\u0131m modundas\u0131n\u0131z. Buna ayn\u0131 zamanda tasar\u0131m zaman\u0131 da denir.<\/li><li> <strong>Execution mode<\/strong> : Bu \u015fekilde \u00e7al\u0131\u015fan kodu test etmek i\u00e7in kod \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, y\u00fcr\u00fctme modundas\u0131n\u0131z demektir. Bu modu ayarlaman\u0131n en iyi \u00f6rne\u011fi, ara\u00e7 \u00e7ubu\u011fundaki \u00c7al\u0131\u015ft\u0131r d\u00fc\u011fmesini kullanarak kod \u00e7al\u0131\u015ft\u0131rman\u0131zd\u0131r. Buna y\u00fcr\u00fctme s\u00fcresi de denir.<\/li><li> <strong>Duraklatma Modu:<\/strong> Bir kod \u00e7al\u0131\u015f\u0131rken ve y\u00fcr\u00fctme duraklat\u0131ld\u0131\u011f\u0131nda, o anda duraklatma modundas\u0131n\u0131zd\u0131r. Bu modda kodu ad\u0131m ad\u0131m \u00e7al\u0131\u015ft\u0131rabilirsiniz. Buna hata ay\u0131klama da denir.<\/li><\/ul><h2 class=\"wp-block-heading\"> VB D\u00fczenleyiciyle PRO Gibi \u00c7al\u0131\u015fmaya Y\u00f6nelik \u0130pu\u00e7lar\u0131<\/h2><h3 class=\"wp-block-heading\"> Kodlara yorum ekleyin<\/h3><p> VBA&#8217;daki di\u011fer programlama dilleri gibi, bu kodun nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 tan\u0131mlamak i\u00e7in yorumlar\u0131 da kullanabilirsiniz. Yorumlar\u0131 kullanmak iyi bir al\u0131\u015fkanl\u0131kt\u0131r ve size bir\u00e7ok y\u00f6nden yard\u0131mc\u0131 olabilir.<\/p><ul><li> <em>Par\u00e7a de\u011fi\u015fiklikleri<\/em><\/li><li> <em>Program\u0131n ileti\u015fim bilgileri<\/em><\/li><li> <em>Kodla ilgili sorun nas\u0131l giderilir<\/em><\/li><li> <em>Ve daha fazlas\u0131<\/em><\/li><\/ul><p> Yorum eklemek i\u00e7in kesme i\u015faretini ve ard\u0131ndan kod sat\u0131r\u0131n\u0131 yazman\u0131z gerekir.<\/p><p> <strong>\u0130lgili \u0130pucu<\/strong> : <a href=\"https:\/\/exceladvisor.org\/tr\/yorum\/\">VBA Yorum Blo\u011fu<\/a><\/p><h3 class=\"wp-block-heading\"> H\u0131zl\u0131 bilgi<\/h3><p> \u015eimdi bir <a href=\"https:\/\/exceladvisor.org\/tr\/islevler\/\">VBA i\u015flevi<\/a> ( <a href=\"https:\/\/exceladvisor.org\/tr\/sol\/\">VBA LEFT \u0130\u015flevi<\/a> ) ekledi\u011fim a\u015fa\u011f\u0131daki \u00f6rne\u011fe bak\u0131n ve i\u015flev ad\u0131n\u0131 yazd\u0131\u011f\u0131m anda, tan\u0131mlamam gereken t\u00fcm arg\u00fcmanlar i\u00e7in bana bir ara\u00e7 ipucu g\u00f6steriyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49122\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/31-info-rapide.png\" sizes=\"auto, \" srcset=\"\" alt=\"31-h\u0131zl\u0131 bilgi\" width=\"283\" height=\"184\"><\/figure><\/div><p> Ayr\u0131ca Control + I k\u0131sayol tu\u015funu kullanabilir veya D\u00dcZENLE men\u00fcs\u00fcnden H\u0131zl\u0131 Bilgi se\u00e7ene\u011fini kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49123\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/32-touches-de-raccourci-controle-i.png\" sizes=\"auto, \" srcset=\"\" alt=\"32-k\u0131sayol tu\u015flar\u0131-kontrol-i\" width=\"275\" height=\"520\"><\/figure><\/div><h3 class=\"wp-block-heading\"> \u00dcyeleri Otomatik Listele<\/h3><p> VBA&#8217;daki her nesne, \u00f6zellikler ve y\u00f6ntemlerle birlikte gelir ve kod penceresine bir nesne veya komut ekleyip (.) girdi\u011finizde, size o nesneyle birlikte gelen \u00f6zelliklerin ve y\u00f6ntemlerin tam listesini g\u00f6sterir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49124\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/33-membres-de-la-liste-automatique.png\" sizes=\"auto, \" srcset=\"\" alt=\"otomatik liste \u00fcyeleri\" width=\"398\" height=\"261\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte, aral\u0131\u011f\u0131n border \u00f6zelli\u011finden sonra (.) ekledi\u011fimde, bana mevcut t\u00fcm eri\u015filebilir \u00f6zellikleri g\u00f6sterdi.<\/p><h3 class=\"wp-block-heading\"> Sabitlerin listesi<\/h3><p> Bir \u00f6zellik veya y\u00f6ntem i\u00e7in ifadeler tan\u0131mlarken mevcut sabitlerin listesini kullanabilirsiniz. A\u015fa\u011f\u0131daki \u00f6rnekte <strong>Border Near<\/strong> y\u00f6ntemini kullan\u0131rken a\u011f\u0131rl\u0131k arg\u00fcman\u0131 i\u00e7in mevcut t\u00fcm sabitleri g\u00f6sterdi. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49125\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/34-constantes-de-liste.png\" sizes=\"auto, \" srcset=\"\" alt=\"sabitleri listele\" width=\"442\" height=\"209\"><\/figure><\/div><p> Sabitlerin listesini almak i\u00e7in Control + Shift + J k\u0131sayol tu\u015funu kullanabilir veya ayr\u0131ca d\u00fczenleme men\u00fcs\u00fcne gidip oradan se\u00e7ene\u011fi kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49126\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/35-touche-de-raccourci-control-shift-j.png\" sizes=\"auto, \" srcset=\"\" alt=\"k\u0131sayol tu\u015fu-kontrol-shift-j\" width=\"314\" height=\"167\"><\/figure><\/div><h3 class=\"wp-block-heading\"> A\u00e7\u0131k se\u00e7ene\u011fi etkinle\u015ftir<\/h3><p> VBA kodlar\u0131 yazarken de\u011fi\u015fken kullanman\u0131z gerekecektir ve de\u011fi\u015fkenleri kullan\u0131rken en \u00f6nemli \u015feylerden biri onlar\u0131n veri tipini bildirmektir. Ve bunu beyan etmeyi unutman\u0131z m\u00fcmk\u00fcnd\u00fcr.<\/p><p> Ancak a\u00e7\u0131k se\u00e7enek ifadesini kulland\u0131\u011f\u0131n\u0131zda, kulland\u0131\u011f\u0131n\u0131z her de\u011fi\u015fken i\u00e7in veri t\u00fcr\u00fcn\u00fc bildirmeniz gerekir; bunu yapmazsan\u0131z VBA bir hata mesaj\u0131 g\u00f6r\u00fcnt\u00fcler. Bu, her de\u011fi\u015fkeni veri t\u00fcr\u00fcyle bildirmeye kendinizi zorlamak gibidir. Bunu yapmak i\u00e7in ara\u00e7lar men\u00fcs\u00fcne gidip se\u00e7enekleri a\u00e7abilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49127\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/36-activer-loption-explicite.png\" sizes=\"auto, \" srcset=\"\" alt=\"etkinle\u015ftirme-se\u00e7enek-a\u00e7\u0131k\" width=\"287\" height=\"229\"><\/figure><\/div><p> Se\u00e7enekler aras\u0131nda \u201cDe\u011fi\u015fken bildirimi iste\u201d kutusunu i\u015faretleyin ve Tamam&#8217;a t\u0131klay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49129\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/37-necessitent-une-declaration-de-variable.png\" sizes=\"auto, \" srcset=\"\" alt=\"zorunlu de\u011fi\u015fken bildirimi\" width=\"570\" height=\"346\"><\/figure><\/div><p> Art\u0131k her mod\u00fcl\u00fcn ba\u015flang\u0131\u00e7ta bir Option Explicit ifadesi olacak ve her de\u011fi\u015fkeni bildirmeniz gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49130\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/38-option-explicite.png\" sizes=\"auto, \" srcset=\"\" alt=\"a\u00e7\u0131k se\u00e7enek\" width=\"320\" height=\"69\"><\/figure><\/div><h3 class=\"wp-block-heading\"> Kod penceresi g\u00f6r\u00fcn\u00fcm\u00fcn\u00fc de\u011fi\u015ftirme<\/h3><p> Tek bir kod penceresine birden fazla kod yazabildi\u011finizde ve VBA bunlar\u0131 bir ay\u0131r\u0131c\u0131yla ay\u0131rd\u0131\u011f\u0131nda ancak daha odaklanm\u0131\u015f bir g\u00f6r\u00fcn\u00fcme sahip olmak istiyorsan\u0131z kod penceresi g\u00f6r\u00fcn\u00fcm\u00fcn\u00fc de\u011fi\u015ftirebilirsiniz. A\u015fa\u011f\u0131da tek bir mod\u00fclde kodlar\u0131m var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49131\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/39-changer-la-vue-de-la-fenetre-de-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"pencere g\u00f6r\u00fcn\u00fcm\u00fc kodunu de\u011fi\u015ftir\" width=\"435\" height=\"508\"><\/figure><\/div><p> Ancak bu g\u00f6r\u00fcn\u00fcm\u00fc pencerenin sol alt k\u0131sm\u0131ndaki g\u00f6r\u00fcn\u00fcm butonlar\u0131ndan de\u011fi\u015ftirebilirim. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49132\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/40-en-bas-a-gauche-de-la-fenetre.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"389\" height=\"321\"><\/figure><\/div><p> Art\u0131k yaln\u0131zca etkin kod g\u00f6r\u00fcn\u00fcr.<\/p><h3 class=\"wp-block-heading\"> Kodu ad\u0131m ad\u0131m \u00e7al\u0131\u015ft\u0131r\u0131n<\/h3><p> VBA kodunu yazd\u0131\u011f\u0131n\u0131zda bu kodun \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda olu\u015fabilecek bir hata veya hata i\u00e7ermesi m\u00fcmk\u00fcnd\u00fcr. Bu durumda en iyi yol bu kodu ad\u0131m ad\u0131m \u00e7al\u0131\u015ft\u0131rmak ve her kod sat\u0131r\u0131n\u0131 do\u011frulamakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49134\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/42-executer-un-code-pas-a-pas.png\" sizes=\"auto, \" srcset=\"\" alt=\"kodu ad\u0131m ad\u0131m \u00e7al\u0131\u015ft\u0131r\" width=\"447\" height=\"397\"><\/figure><\/div><p> Bunu yapmak i\u00e7in F8 k\u0131sayol tu\u015funu kullanarak kodu sat\u0131r sat\u0131r \u00e7al\u0131\u015ft\u0131rabilir veya hata ay\u0131klama men\u00fcs\u00fcndeki ad\u0131m ad\u0131m se\u00e7ene\u011fini kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49135\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/43-touche-de-raccourci-f8-pour-executer-une-ligne-de-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir kod sat\u0131r\u0131n\u0131-\u00e7al\u0131\u015ft\u0131rmak i\u00e7in f8-k\u0131sayol tu\u015fu43-kod sat\u0131r\u0131n\u0131-\u00e7al\u0131\u015ft\u0131rmak i\u00e7in-f8-k\u0131sayol tu\u015fu\" width=\"335\" height=\"104\"><\/figure><\/div><p> Ayr\u0131ca hata ay\u0131klama ara\u00e7 \u00e7ubu\u011funda kullanabilece\u011finiz bir d\u00fc\u011fme de bulunmaktad\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49136\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/44-bouton-sur-la-barre-doutils-de-debogage.png\" sizes=\"auto, \" srcset=\"\" alt=\"hata ay\u0131klama ara\u00e7 \u00e7ubu\u011fu d\u00fc\u011fmesi\" width=\"464\" height=\"185\"><\/figure><\/div><h3 class=\"wp-block-heading\"> Kod girintisi<\/h3><p> Uzun ve karma\u015f\u0131k kodlar yazarken, onlar\u0131 daha sonra anlayabilmeniz i\u00e7in do\u011fru \u015fekilde yap\u0131land\u0131rman\u0131z \u00f6nemlidir. Bunun i\u00e7in i\u015fe yarayan bir \u015fey var; \u0130NDERLEME. Girintileme temel olarak kodun sekmeler kullan\u0131larak yap\u0131land\u0131r\u0131lmas\u0131d\u0131r; a\u015fa\u011f\u0131da bir \u00f6rnek verilmi\u015ftir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49138\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/46-indentation-de-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"kod girintisi\" width=\"335\" height=\"264\"><\/figure><\/div><p> Bir sat\u0131ra girinti eklemek i\u00e7in klavyedeki SEKME tu\u015funu kullanabilir veya ara\u00e7 \u00e7ubu\u011fundaki girinti\/negatif girinti d\u00fc\u011fmelerini de kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49139\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/47-boutons-dindentation.png\" sizes=\"auto, \" srcset=\"\" alt=\"girinti d\u00fc\u011fmeleri\" width=\"461\" height=\"86\"><\/figure><\/div><h3 class=\"wp-block-heading\"> Bir metin dosyas\u0131ndan kod alma<\/h3><p> Visual Basic D\u00fczenleyicisi, VBA kodlar\u0131n\u0131 kopyalay\u0131p yap\u0131\u015ft\u0131rmadan bir metin dosyas\u0131ndan i\u00e7e aktarman\u0131za olanak tan\u0131r. Bir mod\u00fcl ekledikten sonra ekle men\u00fcs\u00fcne gidebilir ve oradan dosya se\u00e7ene\u011fini se\u00e7ebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49140\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/48-obtenir-le-code-dun-fichier-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir metin dosyas\u0131n\u0131n kodunu al\" width=\"203\" height=\"219\"><\/figure><\/div><p> Metin dosyas\u0131n\u0131 bulabilece\u011finiz ve i\u00e7indeki t\u00fcm kodlar\u0131 ge\u00e7erli mod\u00fcle aktarabilece\u011finiz ileti\u015fim kutusunu a\u00e7ar.<\/p><h3 class=\"wp-block-heading\"> Referans stili R1C1<\/h3><p> Daha \u00f6nce R1C1 referans stiliyle \u00e7al\u0131\u015ft\u0131ysan\u0131z, onunla daha kolay kod yazmak konusunda bu noktada hemfikir olaca\u011f\u0131n\u0131zdan eminim.<\/p><p> <a href=\"https:\/\/exceladvisor.org\/tr\/r1c1\/\">Referans stili R1C1<\/a><\/p><h3 class=\"wp-block-heading\"> Sat\u0131r sonu<\/h3><p> Kod penceresinin geni\u015fli\u011fini ayarlay\u0131p b\u00fcy\u00fctebilseniz bile, okumay\u0131 zorla\u015ft\u0131ran uzun kod sat\u0131rlar\u0131yla u\u011fra\u015ft\u0131\u011f\u0131n\u0131z zamanlar olabilir.<\/p><p> Bunu d\u00fczeltmenin en iyi yolu sat\u0131r sonu eklemektir. Temel olarak, yeni sat\u0131r, yeni sat\u0131r karakterini kullanarak bir sat\u0131r\u0131 iki sat\u0131ra b\u00f6ld\u00fc\u011f\u00fcn\u00fczde olu\u015fan bir \u015feydir.<\/p><p> Sat\u0131r sonu eklemek i\u00e7in BO\u015eLUK ve ALT \u00c7\u0130ZG\u0130 kullan\u0131n ve Enter tu\u015funa bas\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49141\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/49-saut-de-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"sat\u0131r sonu\" width=\"259\" height=\"113\"><\/figure><\/div><h3 class=\"wp-block-heading\"> D\u00fczen<\/h3><p> Kullan\u0131c\u0131 aray\u00fcz\u00fc s\u00f6z konusu oldu\u011funda Visual Basic edit\u00f6r\u00fc pek iyi g\u00f6r\u00fcnm\u00fcyor. Ancak onu \u00f6zelle\u015ftirmek veya g\u00f6r\u00fcn\u00fcm\u00fcn\u00fc istedi\u011finiz \u015fekilde de\u011fi\u015ftirmek i\u00e7in kullanabilece\u011finiz birka\u00e7 bi\u00e7imlendirme se\u00e7ene\u011fi vard\u0131r.<\/p><p> Ara\u00e7lar men\u00fcs\u00fc se\u00e7enekleri d\u00fczenleyici format\u0131ndan, yaz\u0131 tipi stili boyutunu veya arka plan rengini de de\u011fi\u015ftirebilece\u011finiz formatlama se\u00e7ene\u011fine gidebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49142\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/50-options-de-formatage.png\" sizes=\"auto, \" srcset=\"\" alt=\"Bi\u00e7imlendirme se\u00e7ene\u011fi 50\" width=\"542\" height=\"329\"><\/figure><\/div><p> Karanl\u0131k bir tema i\u00e7in VBA d\u00fczenleyicisini \u00f6zelle\u015ftirmeyi anlatan <a href=\"https:\/\/www.youtube.com\/watch?v=K_sj0GBSLew\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"this video (opens in a new tab)\">bu videoyu<\/a> izleyin.<\/p><h3 class=\"wp-block-heading\"> Ki\u015fisel Makrolar \u00c7al\u0131\u015fma Kitab\u0131<\/h3><p> Kulland\u0131\u011f\u0131n\u0131z herhangi bir \u00e7al\u0131\u015fma kitab\u0131nda eri\u015fmeniz gereken makrolar olabilir.<\/p><p> Bu durumda, t\u00fcm \u00f6nemli kodlar\u0131 tek bir yerde saklaman\u0131za yard\u0131mc\u0131 olabilecek <a href=\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/\"><strong>Ki\u015fisel Makro Ba\u011flay\u0131c\u0131&#8217;y\u0131<\/strong><\/a> kullanabilir ve bunlara t\u00fcm \u00e7al\u0131\u015fma kitaplar\u0131ndan eri\u015febilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49147\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/55-cahier-de-macros-personnel.png\" sizes=\"auto, \" srcset=\"\" alt=\"55-makro-ki\u015fisel-cilt\" width=\"312\" height=\"198\"><\/figure><\/div><h3 class=\"wp-block-heading\"> Yer imlerini kullanma<\/h3><p> Visual Basic D\u00fczenleyicisi, Sa\u011f T\u0131klama <strong>\u27a4<\/strong> Ge\u00e7i\u015f <strong>\u27a4<\/strong> Yer \u0130mi&#8217;nden bir sat\u0131ra yer imleri eklemenizi sa\u011flar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49148\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/56-utiliser-des-signets.png\" sizes=\"auto, \" srcset=\"\" alt=\"56-kullan\u0131m-yer imleri\" width=\"326\" height=\"362\"><\/figure><\/div><p> Daha sonra, d\u00fczenleme men\u00fcs\u00fc se\u00e7ene\u011finden yer imleri aras\u0131nda da gezinebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49149\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/57-naviguer-entre-les-signets.png\" sizes=\"auto, \" srcset=\"\" alt=\"57-yer imleri aras\u0131nda-gezinme\" width=\"449\" height=\"535\"><\/figure><\/div><h3 class=\"wp-block-heading\"> S\u00f6zdizimi Kontrol\u00fc<\/h3><p> Kod penceresine kod yazd\u0131\u011f\u0131n\u0131zda VBA s\u00f6z dizimi hatas\u0131n\u0131 kontrol eder ve s\u00f6z dizimi hatas\u0131 yapt\u0131\u011f\u0131n\u0131zda sizi uyar\u0131r. Bu se\u00e7enek varsay\u0131lan olarak etkindir ancak VBA&#8217;n\u0131n her hata yapt\u0131\u011f\u0131n\u0131zda sizi uyarmas\u0131n\u0131 istemiyorsan\u0131z bunu devre d\u0131\u015f\u0131 da b\u0131rakabilirsiniz.<\/p><p> <strong>Ara\u00e7lar men\u00fcs\u00fc<\/strong> <strong>\u27a4 Se\u00e7enekler<\/strong> <strong>\u27a4 D\u00fczenleyici sekmesi<\/strong> <strong>\u27a4 Otomatik s\u00f6zdizimi denetimi.<\/strong> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49150\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/58-verification-de-la-syntaxe.png\" sizes=\"auto, \" srcset=\"\" alt=\"58-s\u00f6zdizimi kontrol\u00fc\" width=\"605\" height=\"368\"><\/figure><\/div><p> Ancak bunu devre d\u0131\u015f\u0131 b\u0131rakman\u0131z\u0131 \u00f6nermiyorum \u00e7\u00fcnk\u00fc kod yazarken yapt\u0131\u011f\u0131n\u0131z t\u00fcm s\u00f6zdizimi hatalar\u0131n\u0131 tan\u0131mlaman\u0131za yard\u0131mc\u0131 olabilir.<\/p><h3 class=\"wp-block-heading\"> Makrolar\u0131n listesi<\/h3><p> Bir mod\u00fclde \u00e7ok fazla makronuz varsa, t\u00fcm makrolar\u0131 g\u00f6rmek i\u00e7in kullanabilece\u011finiz bir se\u00e7enek vard\u0131r (Ara\u00e7lar \u27a4 Makro). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49151\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/59-liste-de-macros.png\" sizes=\"auto, \" srcset=\"\" alt=\"59-makro listesi\" width=\"513\" height=\"390\"><\/figure><\/div><p> Bu liste se\u00e7ene\u011fini kullanman\u0131n en b\u00fcy\u00fck avantajlar\u0131ndan biri, bu yordama gitmeden bir makroyu \u00e7al\u0131\u015ft\u0131rabilmeniz, silebilmeniz ve de\u011fi\u015ftirebilmenizdir.<\/p><h3 class=\"wp-block-heading\"> Bir projeyi parolayla kilitleme<\/h3><p> Visual Basic D\u00fczenleyici ayr\u0131ca bir mod\u00fcl\u00fc parolayla kilitleme olana\u011f\u0131 da sa\u011flar. Yani kullan\u0131c\u0131lar\u0131n kodu bilmesini ve de\u011fi\u015ftirmemesini istemiyorsan\u0131z bu se\u00e7ene\u011fi kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49152\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/60-verrouiller-un-projet-avec-un-mot-de-passe.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir-projeyi-\u015fifreyle-kilitle\" width=\"278\" height=\"252\"><\/figure><\/div><p> Ara\u00e7lar Men\u00fcs\u00fc \u27a4 VBAProject \u00d6zellikleri \u27a4 Koruma Sekmesi <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49153\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/61-proprietes-vbaproject.png\" sizes=\"auto, \" srcset=\"\" alt=\"vbaproject-\u00f6zellikleri\" width=\"437\" height=\"377\"><\/figure><\/div><h3 class=\"wp-block-heading\"> \u00d6nemli k\u0131sayol tu\u015flar\u0131<\/h3><ul><li> <strong>Shift + F7<\/strong> : Nesne Taray\u0131c\u0131.<\/li><li> <strong>F5<\/strong> : Makroyu \u00e7al\u0131\u015ft\u0131r.<\/li><li> <strong>Sekme<\/strong> : Girinti ekleyin.<\/li><li> <strong>Alt + Q<\/strong> : Kapat.<\/li><li> <strong>F8<\/strong> : Girin.<\/li><li> <strong>Control + H<\/strong> : Bul ve de\u011fi\u015ftir.<\/li><li> <strong>Control + G<\/strong> : Anl\u0131k pencere.<\/li><li> <strong>Control + R<\/strong> : Proje Gezgini.<\/li><li> <strong>F4<\/strong> : \u00d6zellikler penceresi.<\/li><\/ul><p> Baz\u0131 HAR\u0130KA Klavye K\u0131sayollar\u0131n\u0131 \u00d6\u011frenin: <a href=\"https:\/\/exceladvisor.org\/tr\/klavye-kisayollari\/\"><strong>Excel Klavye K\u0131sayollar\u0131 Hile Sayfas\u0131<\/strong><\/a><\/p><h2 class=\"wp-block-heading\"> Visual Basic D\u00fczenleyiciye Alternatif<\/h2><p> Makro yazmak i\u00e7in pek \u00e7ok ba\u015fka d\u00fczenleyiciyi denedim, ancak buldu\u011fum sorun Intellisense olmadan Visual Basic d\u00fczenleyicisinin kendisinden ba\u015fka herhangi bir \u015feyi kullanman\u0131n ger\u00e7ekten zor olmas\u0131yd\u0131. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49154\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/62-alternatives-a-lediteur-de-base-visuel.png\" sizes=\"auto, \" srcset=\"\" alt=\"temel g\u00f6rsel d\u00fczenleyiciye alternatif\" width=\"554\" height=\"399\"><\/figure><\/div><p> VBA edit\u00f6r\u00fc Excel ile \u00e7al\u0131\u015f\u0131r, kodlar\u0131n\u0131z\u0131 an\u0131nda test edebilir ve \u00e7al\u0131\u015fma kitab\u0131n\u0131za kaydedebilirsiniz. Ama burada deneyebilece\u011finiz baz\u0131 isimler var.<\/p><p> <a href=\"https:\/\/code.visualstudio.com\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Visual Studio Code (opens in a new tab)\">Visual Studio Kodu<\/a> | <a href=\"https:\/\/www.ultraedit.com\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Ultra Edit (opens in a new tab)\">Ultra D\u00fczenleme<\/a><\/p><h2 class=\"wp-block-heading\"> Paket servis<\/h2><ul><li> Kod penceresini b\u00fcy\u00fctebilir veya k\u00fc\u00e7\u00fcltebilirsiniz.<\/li><li> Bir projenin ad\u0131n\u0131 istedi\u011finiz zaman de\u011fi\u015ftirebilirsiniz.<\/li><li> Proje penceresi d\u00fczenleyicide gezinmenin en iyi yoludur.<\/li><li> Kod yazarken hata olmas\u0131 durumunda k\u0131rm\u0131z\u0131 \u00e7izgi \u00e7izecektir.<\/li><li> Ayr\u0131ca sa\u011f t\u0131klama men\u00fcs\u00fc ge\u00e7i\u015f yer iminden bir kod sat\u0131r\u0131na yer i\u015fareti koyabilirsiniz.<\/li><li> Bir Excel \u00e7al\u0131\u015fma kitab\u0131n\u0131 a\u00e7madan Visual Basic d\u00fczenleyicisini kullanamazs\u0131n\u0131z.<\/li><\/ul><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/vba\/\">VBA nedir<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/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><div class=\"schema-faq wp-block-yoast-faq-block\"><div id=\"faq-question-1585401860201\" class=\"schema-faq-section\"> <strong class=\"schema-faq-question\">Visual Basic D\u00fczenleyiciyi kurmal\u0131 m\u0131y\u0131m?<\/strong><p class=\"schema-faq-answer\"> Hay\u0131r. Visual Basic D\u00fczenleyicisini kurman\u0131za gerek yoktur. Microsoft Office uygulamalar\u0131yla \u00f6nceden y\u00fcklenmi\u015f olarak gelir.<\/p><\/div><div id=\"faq-question-1585402056316\" class=\"schema-faq-section\"> <strong class=\"schema-faq-question\">\u015eeritte Geli\u015ftirici sekmesi yoksa ne olur?<\/strong><p class=\"schema-faq-answer\"> Excel \u015feridinde geli\u015ftirici sekmeniz yoksa bunu Excel \u015feridinden etkinle\u015ftirebilirsiniz.<\/p><\/div><div id=\"faq-question-1585402823785\" class=\"schema-faq-section\"> <strong class=\"schema-faq-question\">Visual Basic D\u00fczenleyiciye alternatif var m\u0131?<\/strong><p class=\"schema-faq-answer\"> Tam olarak de\u011fil. VBE&#8217;de bulunan IntelliSense, onu VBA kodlar\u0131 yazmak i\u00e7in m\u00fckemmel k\u0131lar.<\/p><\/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-1511","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>Windows i\u00e7in Excel Visual Basic D\u00fczenleyicisi (VBE) - Mac (2023 K\u0131lavuzu)<\/title>\n<meta name=\"description\" content=\"Visual Basic Editor, VBA i\u00e7in bir kod d\u00fczenleyicisidir. Bu ayr\u0131 bir uygulamad\u0131r ancak yaln\u0131zca Excel ile kullanabilirsiniz.\" \/>\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\/temel-gorsel-duzenleyici\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Windows i\u00e7in Excel Visual Basic D\u00fczenleyicisi (VBE) - Mac (2023 K\u0131lavuzu)\" \/>\n<meta property=\"og:description\" content=\"Visual Basic Editor, VBA i\u00e7in bir kod d\u00fczenleyicisidir. Bu ayr\u0131 bir uygulamad\u0131r ancak yaln\u0131zca Excel ile kullanabilirsiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:08:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-vbe.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=\"20 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/\",\"name\":\"Windows i\u00e7in Excel Visual Basic D\u00fczenleyicisi (VBE) - Mac (2023 K\u0131lavuzu)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-vbe.png\",\"datePublished\":\"2023-11-18T20:22:47+00:00\",\"dateModified\":\"2023-12-10T06:08:03+00:00\",\"description\":\"Visual Basic Editor, VBA i\u00e7in bir kod d\u00fczenleyicisidir. Bu ayr\u0131 bir uygulamad\u0131r ancak yaln\u0131zca Excel ile kullanabilirsiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-vbe.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-vbe.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Windows ve mac i\u00e7in excel visual basic d\u00fczenleyicisi\"}]},{\"@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":"Windows i\u00e7in Excel Visual Basic D\u00fczenleyicisi (VBE) - Mac (2023 K\u0131lavuzu)","description":"Visual Basic Editor, VBA i\u00e7in bir kod d\u00fczenleyicisidir. Bu ayr\u0131 bir uygulamad\u0131r ancak yaln\u0131zca Excel ile kullanabilirsiniz.","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\/temel-gorsel-duzenleyici\/","og_locale":"tr_TR","og_type":"article","og_title":"Windows i\u00e7in Excel Visual Basic D\u00fczenleyicisi (VBE) - Mac (2023 K\u0131lavuzu)","og_description":"Visual Basic Editor, VBA i\u00e7in bir kod d\u00fczenleyicisidir. Bu ayr\u0131 bir uygulamad\u0131r ancak yaln\u0131zca Excel ile kullanabilirsiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:08:03+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-vbe.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"20 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/","url":"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/","name":"Windows i\u00e7in Excel Visual Basic D\u00fczenleyicisi (VBE) - Mac (2023 K\u0131lavuzu)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-vbe.png","datePublished":"2023-11-18T20:22:47+00:00","dateModified":"2023-12-10T06:08:03+00:00","description":"Visual Basic Editor, VBA i\u00e7in bir kod d\u00fczenleyicisidir. Bu ayr\u0131 bir uygulamad\u0131r ancak yaln\u0131zca Excel ile kullanabilirsiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-vbe.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-vbe.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Windows ve mac i\u00e7in excel visual basic d\u00fczenleyicisi"}]},{"@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\/1511","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=1511"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1511\/revisions"}],"predecessor-version":[{"id":2966,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1511\/revisions\/2966"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}