{"id":2122,"date":"2023-09-30T16:50:08","date_gmt":"2023-09-30T16:50:08","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/degiskenler\/"},"modified":"2023-12-10T06:05:26","modified_gmt":"2023-12-10T06:05:26","slug":"degiskenler","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/degiskenler\/","title":{"rendered":"Vba de\u011fi\u015fkenleri hakk\u0131nda bilmeniz gereken her \u015fey"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-442598663\"><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> <h2 class=\"wp-block-heading\">De\u011fi\u015fken VBA<\/h2><p> VBA&#8217;da bir de\u011fi\u015fken, kendisi sisteminizde saklanan bir saklama kutusu gibidir, ancak sizin i\u00e7in orada bir de\u011fer saklayabilir ve bu de\u011feri kodunuzda kullanabilir ve isterseniz bu de\u011feri de\u011fi\u015ftirebilirsiniz (ad\u0131ndan da anla\u015f\u0131laca\u011f\u0131 gibi, &#8220;VARIABLE&#8221; \u201d, de\u011feri sabit olmayan bir \u015feydir).<\/p><p> Bir de\u011fi\u015fkeni bildirmek i\u00e7in basit bir prosed\u00fcr izlemelisiniz:<\/p><ol><li> Ba\u015flang\u0131\u00e7ta \u201cDim\u201d anahtar kelimesini kullan\u0131n.<\/li><li> De\u011fi\u015fken i\u00e7in bir ad belirtin.<\/li><li> \u0130smin ard\u0131ndan \u201cAs\u201d anahtar kelimesini kullan\u0131n.<\/li><li> <span style=\"font-weight: 400;\">Atamak istedi\u011finiz de\u011fere g\u00f6re de\u011fi\u015fkenin \u201cVeri T\u00fcr\u00fc\u201dn\u00fc belirtin.<\/span><\/li><\/ol><p> Burada \u201cstartDate\u201d ad\u0131n\u0131 kulland\u0131k ve \u201cTarih\u201d veri tipini belirledik. Bir de\u011fi\u015fkeni tan\u0131mlad\u0131ktan sonra ona bir de\u011fer atayabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim startDate As Date startDate = \u201c11\/10\/2018\u201d<\/code><\/pre><p> Art\u0131k kodunuzda ba\u015flang\u0131\u00e7 tarihini kulland\u0131\u011f\u0131n\u0131zda Excel, verdi\u011finiz tarihi kullan\u0131r.<\/p><h2 class=\"wp-block-heading\"> Veri tipleri<\/h2><p> VBA&#8217;da veri t\u00fcrleri temel olarak bir de\u011feri bir de\u011fi\u015fkene veya sabite kaydederken belirtmeniz gereken veri t\u00fcrleridir. \u00d6rne\u011fin, bir tarihi bir de\u011fi\u015fkende saklamak istiyorsan\u0131z, \u00f6nce o tarih de\u011fi\u015fkenini veri t\u00fcr\u00fc olarak bildirmeniz gerekir.<\/p><h3 class=\"wp-block-heading\"> A\u00e7\u0131klanan Veri T\u00fcrleri<\/h3><p> \u0130\u015fte VBA&#8217;da kullanabilece\u011finiz veri t\u00fcrlerinin tam listesi. <\/p><figure class=\"wp-block-table is-style-stripes\"><table class=\"mtr-table mtr-thead-th\"><thead><tr><th class=\"has-text-align-center mtr-th-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"> Veri tipi <\/div><\/th><th class=\"has-text-align-center mtr-th-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"> Kullan\u0131lan bayt say\u0131s\u0131 <\/div><\/th><th class=\"has-text-align-left mtr-th-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"> De\u011fer aral\u0131\u011f\u0131 <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"> Bayt <\/div><\/td><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"> 1 bayt <\/div><\/td><td class=\"has-text-align-left mtr-td-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"> 0 ila 255 <\/div><\/td><\/tr><tr><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"> boolean <\/div><\/td><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"> 2 bayt <\/div><\/td><td class=\"has-text-align-left mtr-td-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"> Do\u011fru ya da yanl\u0131\u015f <\/div><\/td><\/tr><tr><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"> T\u00fcm <\/div><\/td><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"> 2 bayt <\/div><\/td><td class=\"has-text-align-left mtr-td-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"> -32,768 ila 32,767 <\/div><\/td><\/tr><tr><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"> Uzun (tamsay\u0131 uzun) <\/div><\/td><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"> 4 bayt <\/div><\/td><td class=\"has-text-align-left mtr-td-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"> -2,147,483,648&#8217;den 2,147,483,647&#8217;ye <\/div><\/td><\/tr><tr><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"> Yaln\u0131z <\/div><\/td><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"> 4 bayt <\/div><\/td><td class=\"has-text-align-left mtr-td-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"> Negatif de\u011ferler i\u00e7in -3,402823E38 ila -1,401298E-45; Pozitif de\u011ferler i\u00e7in 1,401298E-45 ila 3,402823E38 <\/div><\/td><\/tr><tr><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"> \u00c7ift <\/div><\/td><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"> 8 bayt <\/div><\/td><td class=\"has-text-align-left mtr-td-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"> Negatif de\u011ferler i\u00e7in -1,79769313486231E308 ila -4,94065645841247E-324; Pozitif de\u011ferler i\u00e7in 4,94065645841247E-324 ila 1,79769313486232E308 <\/div><\/td><\/tr><tr><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"> Pe\u015fin <\/div><\/td><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"> 8 bayt <\/div><\/td><td class=\"has-text-align-left mtr-td-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"> -922,337,203,685,477,5808 ila 922,337,203,685,477,5807 <\/div><\/td><\/tr><tr><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"> Ondal\u0131k <\/div><\/td><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"> 14 bayt <\/div><\/td><td class=\"has-text-align-left mtr-td-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"> +\/-79 228 162 514 264 337 593 543 950 335 ondal\u0131k noktas\u0131 olmadan; +\/-7,9228162514264337593543950335, virg\u00fcl\u00fcn sa\u011f\u0131nda 28 ondal\u0131k basamakla <\/div><\/td><\/tr><tr><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"> Tarih <\/div><\/td><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"> 8 bayt <\/div><\/td><td class=\"has-text-align-left mtr-td-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"> 1 Ocak 100 &#8211; 31 Aral\u0131k 9999 <\/div><\/td><\/tr><tr><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"> Nesne <\/div><\/td><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"> 4 bayt <\/div><\/td><td class=\"has-text-align-left mtr-td-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"> Herhangi bir nesne referans\u0131 <\/div><\/td><\/tr><tr><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"> Zincir (de\u011fi\u015fken uzunluk) <\/div><\/td><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"> 10 bayt + dize uzunlu\u011fu <\/div><\/td><td class=\"has-text-align-left mtr-td-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"> 0 ila yakla\u015f\u0131k 2 milyar <\/div><\/td><\/tr><tr><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"> Zincir (sabit uzunluk) <\/div><\/td><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"> Zincir uzunlu\u011fu <\/div><\/td><td class=\"has-text-align-left mtr-td-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"> 1 ila yakla\u015f\u0131k 65.400 <\/div><\/td><\/tr><tr><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"> Varyant (say\u0131larla) <\/div><\/td><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"> 16 bayt <\/div><\/td><td class=\"has-text-align-left mtr-td-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"> Double aral\u0131\u011f\u0131na kadar herhangi bir say\u0131sal de\u011fer <\/div><\/td><\/tr><tr><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"> Varyant (karakterli) <\/div><\/td><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"> 22 bayt + dize uzunlu\u011fu <\/div><\/td><td class=\"has-text-align-left mtr-td-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"> De\u011fi\u015fken uzunluklu dizeyle ayn\u0131 aral\u0131k <\/div><\/td><\/tr><tr><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"> Kullan\u0131c\u0131 tan\u0131ml\u0131 <\/div><\/td><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"> \u00c7e\u015fitli <\/div><\/td><td class=\"has-text-align-left mtr-td-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"> Her \u00f6\u011fenin aral\u0131\u011f\u0131, veri t\u00fcr\u00fcn\u00fcn aral\u0131\u011f\u0131yla ayn\u0131d\u0131r <\/div><\/td><\/tr><tr><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Data Type\"><div class=\"mtr-cell-content\"><\/div><\/td><td class=\"has-text-align-center mtr-td-tag\" data-align=\"center\" data-mtr-content=\"Bytes Used\"><div class=\"mtr-cell-content\"><\/div><\/td><td class=\"has-text-align-left mtr-td-tag\" data-align=\"left\" data-mtr-content=\"Range of Values\"><div class=\"mtr-cell-content\"><\/div><\/td><\/tr><\/tbody><\/table><\/figure><p> Bu, de\u011fi\u015fkenler ve <a href=\"https:\/\/exceladvisor.org\/tr\/sabitler\/\">sabitler<\/a> i\u00e7in veri tipinin bildirilmesinde \u00f6nemle tavsiye edilir.<\/p><p> Bir de\u011fi\u015fken veya sabit i\u00e7in veri tipini belirtti\u011finizde verilerinizin ge\u00e7erlili\u011fi sa\u011flan\u0131r ve ge\u00e7ersiz veri tipi girmeniz engellenir. 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 ve VBA, veri t\u00fcr\u00fcn\u00fcn ne olmas\u0131 gerekti\u011fini tahmin etmez.<\/p><p class=\"qt-tip\"> <strong>\u0130pucu:<\/strong> Veri t\u00fcrlerini belirtmeyi atlamaman\u0131n en iyi yolu, herhangi bir koda ba\u015flamadan \u00f6nce mod\u00fcl\u00fcn en \u00fcst\u00fcndeki <a href=\"https:\/\/exceladvisor.org\/tr\/acik-secenek-2\/\">a\u00e7\u0131k se\u00e7ene\u011fini<\/a> kullanmakt\u0131r.<\/p><h2 class=\"wp-block-heading\"> A\u00e7\u0131k\u00e7a veya \u00f6rt\u00fcl\u00fc olarak<\/h2><p> Bir de\u011fi\u015fkeni a\u00e7\u0131k\u00e7a veya \u00f6rt\u00fcl\u00fc olarak bildirebilirsiniz. <strong>A\u00e7\u0131k bildirim, bir de\u011fi\u015fkene de\u011fer atamadan \u00f6nce onu bildirip de\u011ferini ayarlaman\u0131z anlam\u0131na gelir<\/strong> . Bunun AVANTAJI, onu tan\u0131mlaman\u0131z ve veri t\u00fcr\u00fc VBA&#8217;n\u0131n verileri her zaman bu formatta saklamas\u0131d\u0131r.<\/p><p> \u0130\u015fte bir \u00f6rnek:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim myDate As Date<\/code><\/pre><p> Dolay\u0131s\u0131yla bu VBA&#8217;da de\u011fer depolad\u0131\u011f\u0131n\u0131zda, buna her zaman tarih bi\u00e7imi uygulanacakt\u0131r. Ancak \u00f6rt\u00fcl\u00fc bildirimde, bu a\u00e7\u0131k bildirim bildirimiyle u\u011fra\u015fmazs\u0131n\u0131z. Bunun yerine, de\u011fi\u015fkenin de\u011ferini ayarlar ve onu kod ifadesinde kullan\u0131rs\u0131n\u0131z. \u00d6rt\u00fcl\u00fc bildirimde VBA, t\u00fcr\u00fc belirtmedi\u011finiz i\u00e7in verileri Variant de\u011fi\u015fken t\u00fcr\u00fcnde saklar.<\/p><p> Ba\u015fka bir deyi\u015fle, kodunuzda bir de\u011fi\u015fkeni bildirmeden kullan\u0131rsan\u0131z, bu \u00f6rt\u00fcl\u00fcd\u00fcr. A\u015fa\u011f\u0131da \u00f6rt\u00fcl\u00fc bir bildirim \u00f6rne\u011fi verilmi\u015ftir:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">myDate = \u201c11\/10\/1990\u201d<\/code><\/pre><p> De\u011feri bir de\u011fi\u015fkene bu \u015fekilde atayabilirsiniz ve bunu kod ifadelerinizde kullanabilirsiniz. Bana sorarsan\u0131z, bir de\u011fi\u015fkeni kullanmadan \u00f6nce bildirmek her zaman, yani her zaman daha iyidir. Bu yaln\u0131zca iyi bir uygulama olmakla kalmaz, ayn\u0131 zamanda kodunuzun daha h\u0131zl\u0131 \u00e7al\u0131\u015fmas\u0131n\u0131 ve anla\u015f\u0131lmas\u0131n\u0131 da kolayla\u015ft\u0131r\u0131r.<\/p><h2 class=\"wp-block-heading\"> Statik de\u011fi\u015fken<\/h2><p> Peki, sana de\u011fi\u015fkenin de\u011feri de\u011fi\u015ftirebilece\u011fin yer oldu\u011funu s\u00f6ylemi\u015ftim ama bu farkl\u0131 bir \u015fey. Normal bir de\u011fi\u015fkende bir prosed\u00fcr tamamland\u0131\u011f\u0131nda de\u011fi\u015fkende saklanan de\u011fer VBA&#8217;n\u0131n belle\u011finden silinir ancak bu de\u011feri kaybetmek istemiyorsan\u0131z bu de\u011fi\u015fkeni statik hale getirebilirsiniz.<\/p><p> Bir de\u011fi\u015fkeni de\u011feri koruyacak \u015fekilde statik yapmak i\u00e7in, &#8220;Dim&#8221; yerine &#8220;Static&#8221; anahtar kelimesini kullanman\u0131z yeterlidir.<\/p><h2 class=\"wp-block-heading\"> Bir de\u011fi\u015fkeni adland\u0131r\u0131n<\/h2><p> Bir de\u011fi\u015fkene istedi\u011finiz ad\u0131 verebilirsiniz (bu kurallar ayn\u0131 zamanda sabit ve prosed\u00fcr ad\u0131 i\u00e7in de ge\u00e7erlidir), ancak birka\u00e7 kurala uyman\u0131z gerekir:<\/p><ul><li> Alfabe, rakam ve baz\u0131 noktalama i\u015faretlerini kullanabilirsiniz ancak ismin ilk karakteri alfabe olmal\u0131d\u0131r.<\/li><li> Bo\u015fluklar veya noktalar adda kullan\u0131lacak ge\u00e7erli karakterler de\u011fildir ancak ad\u0131n okunabilir olmas\u0131n\u0131 sa\u011flamak i\u00e7in alt \u00e7izgi kullanabilirsiniz.<\/li><li> Bir adda \u00f6zel karakterler kullanamazs\u0131n\u0131z.<\/li><li> Bir ad\u0131n uzunlu\u011fu 254 karakter olabilir ancak anlaml\u0131 olmayan bir ad kullan\u0131lmas\u0131.<\/li><li> \u0130sim i\u00e7in kullanamayaca\u011f\u0131n\u0131z bir\u00e7ok ayr\u0131lm\u0131\u015f kelime vard\u0131r. Bu kelimelerden herhangi birini kullanmaya \u00e7al\u0131\u015f\u0131rsan\u0131z bir hata mesaj\u0131 al\u0131rs\u0131n\u0131z.<\/li><li> VBA vakalar aras\u0131nda ayr\u0131m yapmaz.<\/li><\/ul><h2 class=\"wp-block-heading\"> Kapsam<\/h2><p> Bu noktada prosed\u00fcrleri ve hangi prosed\u00fcr\u00fcn hangi durumda faydal\u0131 oldu\u011funu biliyorsunuz, ayn\u0131 zamanda de\u011fi\u015fkenleri ve veri t\u00fcrlerinin nas\u0131l tan\u0131mlanaca\u011f\u0131n\u0131 da \u00f6\u011freniyorsunuz.<\/p><p> Bir sonraki \u00f6nemli \u015fey, kullan\u0131labilirlik anlam\u0131na gelen kapsam\u0131 anlamakt\u0131r. Kullan\u0131labilece\u011fi yer buras\u0131d\u0131r. Bir de\u011fi\u015fkeni tan\u0131mlad\u0131\u011f\u0131n\u0131zda kapsam, onlar\u0131 ana bilgisayar prosed\u00fcrlerinin d\u0131\u015f\u0131nda kullan\u0131p kullanamayaca\u011f\u0131n\u0131z\u0131 tan\u0131mlar. De\u011fi\u015fken kapsamlar\u0131 tan\u0131mlaman\u0131n \u00fc\u00e7 yolu vard\u0131r (sabit ve hatta t\u00fcm prosed\u00fcrle birlikte).<\/p><ol><li> <strong>Prosed\u00fcr d\u00fczeyi:<\/strong> Bir de\u011fi\u015fkeni yaln\u0131zca onu bildirdi\u011finiz prosed\u00fcrde kullanabilirsiniz.<\/li><li> <strong>Mod\u00fcl d\u00fczeyi (\u00f6zel):<\/strong> Bir de\u011fi\u015fkenin bir mod\u00fcldeki t\u00fcm prosed\u00fcrlerden eri\u015filebilir olmas\u0131n\u0131 sa\u011flar.<\/li><li> <strong>Mod\u00fcl d\u00fczeyi (Genel):<\/strong> Bir de\u011fi\u015fkenin t\u00fcm mod\u00fcllerdeki t\u00fcm prosed\u00fcrlerden eri\u015filebilir olmas\u0131n\u0131 sa\u011flar.<\/li><\/ol><p> Bir de\u011fi\u015fkenin varsay\u0131lan kapsam\u0131, bu de\u011fi\u015fkenin bildirildi\u011fi prosed\u00fcrd\u00fcr (Prosed\u00fcr D\u00fczeyi).<\/p><p> <strong>Ama sizinle ger\u00e7ek d\u00fcnyadan bir \u015fey payla\u015fay\u0131m.<\/strong><\/p><p class=\"grey-note has-cyan-bluish-gray-color has-text-color\"> <em>Ortak \u00e7al\u0131\u015fma alan\u0131nda \u00e7al\u0131\u015f\u0131yorum ve oturdu\u011fum yer \u00fc\u00e7 katl\u0131 binan\u0131n birinci kat\u0131nda.<\/em> Neredeyse her g\u00fcn ayn\u0131 koltukta oturuyorum. Yani prosed\u00fcr d\u00fczeyi kapsam\u0131na sahip bir de\u011fi\u015fken bildirirseniz, onu yaln\u0131zca ayn\u0131 prosed\u00fcr i\u00e7inde kullanabilirsiniz. T\u0131pk\u0131 her g\u00fcn ayn\u0131 katta, ayn\u0131 koltukta oturdu\u011fum gibi. Ama daha fazlas\u0131n\u0131 s\u00f6yleyeyim: Birinci katta otursam da di\u011fer katlardaki her koltu\u011fu da kullanabilirim. A\u015fa\u011f\u0131daki anl\u0131k g\u00f6r\u00fcnt\u00fcde ise herhangi bir i\u015fleme ba\u015flamadan \u00f6nce mod\u00fcl\u00fcn \u00fcst k\u0131sm\u0131ndaki \u201cmyName\u201d de\u011fi\u015fkenini Private anahtar kelimesini kullanarak tan\u0131mlad\u0131k ve \u00fc\u00e7 kodda da bunu kulland\u0131m. Bu mod\u00fcl\u00fc, farkl\u0131 katlara (Prosed\u00fcrler) sahip oldu\u011funuz bir bina olarak d\u00fc\u015f\u00fcn\u00fcn ve de\u011fi\u015fkeni zaten <em>mod\u00fcl\u00fcn ba\u015f\u0131nda tan\u0131mlad\u0131\u011f\u0131n\u0131z i\u00e7in, bu mod\u00fcldeki prosed\u00fcrlerden herhangi birini kullanabilirsiniz. Buna \u00f6zel mod\u00fcl d\u00fczeyinde kapsam belirleme denir. \u015eimdi son olarak \u015funu s\u00f6yleyeyim: Ofisimin \u00fclke genelinde farkl\u0131 \u015fehirlerde \u015fubeleri var ve oraya gidersem o ofislere gidebilir, istersem koltuklardan herhangi birini kullanabilirim. Yani \u00e7al\u0131\u015fma kitab\u0131n\u0131zda farkl\u0131 mod\u00fcller varsa, bir de\u011fi\u015fkeni Public olarak bildirerek t\u00fcm bu mod\u00fcllerde kullanabilirsiniz.<\/em><\/p><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\/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 de\u011fi\u015fken olarak bir aral\u0131k veya h\u00fccre kullanma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/acik-secenek-2\/\">VBA&#8217;da a\u00e7\u0131k se\u00e7enek ifadesi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/degisken-mesaj-kutusu\/\">Mesaj kutusundaki de\u011fi\u015fken<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2122","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA De\u011fi\u015fkenleri: Bildirim, Veri T\u00fcrleri ve Kapsam 2023<\/title>\n<meta name=\"description\" content=\"Bir de\u011fi\u015fken, sisteminizde saklanan bir saklama kutusu gibidir, ancak orada bir de\u011fer saklayabilir.\" \/>\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\/degiskenler\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA De\u011fi\u015fkenleri: Bildirim, Veri T\u00fcrleri ve Kapsam 2023\" \/>\n<meta property=\"og:description\" content=\"Bir de\u011fi\u015fken, sisteminizde saklanan bir saklama kutusu gibidir, ancak orada bir de\u011fer saklayabilir.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/degiskenler\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:05:26+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/degiskenler\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/degiskenler\/\",\"name\":\"VBA De\u011fi\u015fkenleri: Bildirim, Veri T\u00fcrleri ve Kapsam 2023\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"datePublished\":\"2023-09-30T16:50:08+00:00\",\"dateModified\":\"2023-12-10T06:05:26+00:00\",\"description\":\"Bir de\u011fi\u015fken, sisteminizde saklanan bir saklama kutusu gibidir, ancak orada bir de\u011fer saklayabilir.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/degiskenler\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/degiskenler\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/degiskenler\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba de\u011fi\u015fkenleri hakk\u0131nda bilmeniz gereken her \u015fey\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA De\u011fi\u015fkenleri: Bildirim, Veri T\u00fcrleri ve Kapsam 2023","description":"Bir de\u011fi\u015fken, sisteminizde saklanan bir saklama kutusu gibidir, ancak orada bir de\u011fer saklayabilir.","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\/degiskenler\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA De\u011fi\u015fkenleri: Bildirim, Veri T\u00fcrleri ve Kapsam 2023","og_description":"Bir de\u011fi\u015fken, sisteminizde saklanan bir saklama kutusu gibidir, ancak orada bir de\u011fer saklayabilir.","og_url":"https:\/\/exceladvisor.org\/tr\/degiskenler\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:05:26+00:00","twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"7 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/degiskenler\/","url":"https:\/\/exceladvisor.org\/tr\/degiskenler\/","name":"VBA De\u011fi\u015fkenleri: Bildirim, Veri T\u00fcrleri ve Kapsam 2023","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"datePublished":"2023-09-30T16:50:08+00:00","dateModified":"2023-12-10T06:05:26+00:00","description":"Bir de\u011fi\u015fken, sisteminizde saklanan bir saklama kutusu gibidir, ancak orada bir de\u011fer saklayabilir.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/degiskenler\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/degiskenler\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/degiskenler\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba de\u011fi\u015fkenleri hakk\u0131nda bilmeniz gereken her \u015fey"}]},{"@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\/2122","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=2122"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2122\/revisions"}],"predecessor-version":[{"id":2811,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2122\/revisions\/2811"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}