{"id":1518,"date":"2023-11-18T03:01:29","date_gmt":"2023-11-18T03:01:29","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/islevler\/"},"modified":"2023-12-10T05:58:36","modified_gmt":"2023-12-10T05:58:36","slug":"islevler","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/islevler\/","title":{"rendered":"Ana vba i\u015flevleri"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3490179867\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>VBA&#8217;ya ba\u015flad\u0131\u011f\u0131n\u0131zda bir sonraki \u00f6nemli \u015fey, VBA kodunu yazarken yerle\u015fik VBA i\u015flevlerini nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenmektir.<\/p><p> O y\u00fczden burada en iyi 100 VBA (Kategori Bilgesi) fonksiyonunu \u00f6rnekler ve \u00f6rnek kodlarla detayl\u0131 bir \u015fekilde listeledim ve bu fonksiyonlar, her fonksiyonun amac\u0131n\u0131 kolayca anlaman\u0131z\u0131 sa\u011flamak i\u00e7in belirli kategorilerde (10) listelendi.<\/p><p> A\u015fa\u011f\u0131da ana VBA i\u015flevlerinin kategorilerinin listesi bulunmaktad\u0131r; t\u00fcm i\u015flevler bu kategoriler alt\u0131nda listelenmi\u015ftir:<\/p><h2 class=\"wp-block-heading\"> VBA TEXT (Dize) \u0130\u015flevleri<\/h2><p> VBA TEXT i\u015flevleri, bir h\u00fccredeki, bir h\u00fccre aral\u0131\u011f\u0131ndaki veya bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131n veya \u00e7al\u0131\u015fma kitab\u0131n\u0131n tamam\u0131ndaki metin de\u011ferlerini de\u011fi\u015ftirmenize yard\u0131mc\u0131 olur. Basit\u00e7e s\u00f6ylemek gerekirse, bu i\u015flevler metin de\u011ferlerini de\u011fi\u015ftirmek i\u00e7in \u00f6zel olarak tasarlanm\u0131\u015ft\u0131r.<\/p><p> A\u015fa\u011f\u0131da kullanmay\u0131 \u00f6\u011frenebilece\u011finiz 18 MET\u0130N fonksiyonunun bir listesi bulunmaktad\u0131r: <\/p><figure class=\"wp-block-table\"><table class=\"mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> \u0130sim<\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Tan\u0131m <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/bicim\/\">VBA FORMAT i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Belirli bir bi\u00e7imi uygulaman\u0131za ve ard\u0131ndan bu dizeyi sonu\u00e7ta d\u00f6nd\u00fcrmenize yard\u0131mc\u0131 olur.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> VBA INSTR i\u015flevi<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir dizeden bir alt dize arar ve sonu\u00e7ta alt dizenin ba\u015flang\u0131\u00e7 konumunu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/enstrev\/\">VBA INSTRREV i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Ayr\u0131ca bir dizeden bir alt dize arar ve sonu\u00e7ta alt dizenin ba\u015flang\u0131\u00e7 konumunu d\u00f6nd\u00fcr\u00fcr (sa\u011fdan sola bakarak).<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/durumda\/\">VBA LCASE i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir dizeyi, t\u00fcm karakterlerin k\u00fc\u00e7\u00fck oldu\u011fu k\u00fc\u00e7\u00fck harfli bir dizeye d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/sol\/\">VBA SOL i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan karakter say\u0131s\u0131n\u0131 kullanarak (dizenin sol taraf\u0131ndan ba\u015flayarak) bir dizeden bir alt dize d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/vba-len\/\">VBA UZUNLUK i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan de\u011ferdeki karakter say\u0131s\u0131n\u0131 sayar ve bu karakterlerin say\u0131s\u0131 olarak bir say\u0131 d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/kisa-sure\/\">VBA LTRIM i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir dizenin ba\u015ftaki bo\u015fluklar\u0131n\u0131 (sol taraftan) kald\u0131r\u0131r ve sonu\u00e7ta bu bo\u015fluklar olmadan o dizeyi d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/oglen\/\">VBA MID i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Ba\u015flang\u0131\u00e7 konumunu ve sa\u011flanan karakter say\u0131s\u0131n\u0131 kullanarak bir dizeden bir alt dize d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/yer-degistirmek\/\">VBA DE\u011e\u0130\u015eT\u0130R i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir dizeden bir alt dize bulur ve onu ba\u015fka bir alt dizeyle de\u011fi\u015ftirir ve sonu\u00e7ta yeni dizeyi d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/sag\/\">SA\u011e VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan karakter say\u0131s\u0131n\u0131 (dizenin sa\u011f taraf\u0131ndan ba\u015flayarak) kullanarak bir dizeden bir alt dize d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/rtrim\/\">VBA RTRIM i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir dizenin sonundaki bo\u015fluklar\u0131 (sa\u011f tarafta) kald\u0131r\u0131r ve sonu\u00e7ta bu bo\u015fluklar olmadan o dizeyi d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/uzay\/\">VBA BO\u015eLUK i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Kullan\u0131c\u0131 taraf\u0131ndan belirlenen say\u0131da bo\u015fluk i\u00e7eren bir dize olu\u015fturur ve bunu sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/strcomp\/\">VBA STRCOMP i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> \u0130ki dizeyi kar\u015f\u0131la\u015ft\u0131r\u0131r ve sonucu bir tamsay\u0131 olarak d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/strconv\/\">STRCONV VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir dizeyi belirli bir formata d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve sonu\u00e7ta yeni bir dize d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/sicim\/\">VBA STRING i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir karakteri al\u0131r ve onu belirli say\u0131da tekrarlar ve sonu\u00e7ta bir dize olarak d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/ters\/\">VBA STRREVERSE i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir dizeyi tersine \u00e7evirir ve sonu\u00e7ta onu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/duzeltme\/\">VBA TRIM i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir dizenin ba\u015f\u0131ndaki ve sonundaki bo\u015fluklar\u0131 kald\u0131r\u0131r ve sonu\u00e7ta yeni bir dize d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/ucase\/\">VBA UCASE i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir dizeyi, t\u00fcm karakterlerin b\u00fcy\u00fck oldu\u011fu b\u00fcy\u00fck harfli bir dizeye d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/div><\/td><\/tr><\/tbody><\/table><\/figure><h2 class=\"wp-block-heading\"> VBA TAR\u0130H \u0130\u015flevleri<\/h2><p> VBA DATE i\u015flevleri, verilerdeki tarihleri i\u015flemek i\u00e7in \u00f6zel olarak tasarlanm\u0131\u015ft\u0131r. Bu i\u015flevlerle bir tarihin bir k\u0131sm\u0131n\u0131 \u00e7\u0131karabilir, bir tarihten g\u00fcn ekleyebilir veya \u00e7\u0131karabilir ve iki tarih aras\u0131ndaki fark\u0131 yapabilirsiniz.<\/p><p> A\u015fa\u011f\u0131da kullanmay\u0131 \u00f6\u011frenebilece\u011finiz 12 DATE i\u015flevinin bir listesi bulunmaktad\u0131r: <\/p><figure class=\"wp-block-table\"><table class=\"mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <strong>\u0130sim<\/strong><\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> <strong>Tan\u0131m<\/strong> <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-2\/\">VBA TAR\u0130H i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sistem ayarlar\u0131n\u0131 kullanarak sonu\u00e7taki ge\u00e7erli tarih de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-ekleme\/\">VBA DATEADD i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Tarihe (ve saate) bir aral\u0131k ekler.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-bolumu\/\">VBA DATEPARTS i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Tarihin bir b\u00f6l\u00fcm\u00fcn\u00fc (g\u00fcn, ay ve y\u0131l) d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-dizisi\/\">VBA DATESERIAL i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan g\u00fcn, ay ve y\u0131l\u0131 kullanarak bir tarih olu\u015fturur.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-degeri\/\">VBA DATEVALUE i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir dize olarak saklanan bir tarihi veya bir tarihi temsil eden bir dizeyi ger\u00e7ek bir tarihe d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/gun\/\">VBA G\u00dcN i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Ge\u00e7erli bir tarihten g\u00fcn de\u011ferini al\u0131r ve geri kalan bile\u015fenleri (ay ve y\u0131l) yok sayar ve sonu\u00e7ta onu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/dosyatarihisaat\/\">VBA FileDateTime i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir dosyan\u0131n (\u00e7al\u0131\u015fma kitab\u0131) son de\u011fi\u015ftirilme tarihini ve saatini (dize olarak) d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/ay\/\">AY \u0130\u015flev VBA<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Ay de\u011ferini ge\u00e7erli bir tarihten al\u0131r ve geri kalan bile\u015fenleri (g\u00fcn ve y\u0131l) yok sayar ve sonu\u00e7ta onu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/ay-adi\/\">VBA \u0130\u015flevi ADI AY<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Ay numaras\u0131n\u0131 (1&#8217;den 12&#8217;ye kadar) kullanarak ay ad\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/hafta-sonu\/\">VBA HAFTA G\u00dcN\u00dc \u0130\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Belirtilen tarihte haftan\u0131n g\u00fcn\u00fcn\u00fc (1&#8217;den 7&#8217;ye kadar) d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/hafta-ici-adi\/\">WEEKDAYNAME VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> G\u00fcn numaras\u0131n\u0131 kullanarak (0&#8217;dan 7&#8217;ye kadar) g\u00fcn ad\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/yil\/\">VBA YIL i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Ge\u00e7erli bir tarihten y\u0131l de\u011ferini al\u0131r ve geri kalan bile\u015fenleri (g\u00fcn ve ay) yok sayar ve sonu\u00e7ta onu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><\/tbody><\/table><\/figure><h2 class=\"wp-block-heading\"> VBA SAAT \u0130\u015flevleri<\/h2><p> VBA zaman i\u015flevleri, zaman de\u011ferleriyle \u00e7al\u0131\u015fman\u0131za ve isterseniz bunlar\u0131 de\u011fi\u015ftirmenize yard\u0131mc\u0131 olur. Bir zaman de\u011ferinin bir k\u0131sm\u0131n\u0131 \u00e7\u0131karabilir, bir zamana saat, dakika ve saat ekleyebilir ve iki zaman de\u011feri aras\u0131ndaki fark\u0131 hesaplayabilirsiniz.<\/p><p> A\u015fa\u011f\u0131da kullanmay\u0131 \u00f6\u011frenebilece\u011finiz 8 TIME fonksiyonunun bir listesi bulunmaktad\u0131r: <\/p><figure class=\"wp-block-table\"><table class=\"mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <strong>\u0130sim<\/strong><\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> <strong>Tan\u0131m<\/strong> <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> VBA ZAMANI i\u015flevi<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Time de\u011ferini ge\u00e7erli bir zamandan al\u0131r ve geri kalan bile\u015fenleri (dakika ve saniye) yok sayar ve sonu\u00e7ta onu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/2.-dakika\/\">VBA DAK\u0130KA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Ge\u00e7erli bir saatten dakika de\u011ferini al\u0131r ve geri kalan bile\u015fenleri (saat ve saniye) yok sayar ve sonu\u00e7ta onu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/simdi\/\">\u015e\u0130MD\u0130 VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sistem ayarlar\u0131n\u0131 kullanarak sonu\u00e7taki ge\u00e7erli tarih ve saati d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/ikinci\/\">VBA \u0130K\u0130NC\u0130 i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Ge\u00e7erli bir zamandan saniye de\u011ferini al\u0131r ve geri kalan bile\u015fenleri (saat ve dakika) yok sayar ve sonu\u00e7ta onu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/zaman\/\">VBA ZAMANI i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sistem ayarlar\u0131n\u0131 kullanarak sonu\u00e7taki ge\u00e7erli zaman de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/zamanlayici\/\">VBA ZAMANLAYICI i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Gece yar\u0131s\u0131ndan (00:00) bu yana ge\u00e7en saniye say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/zaman-serisi\/\">VBA ZAMAN SER\u0130 i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Kullan\u0131c\u0131 taraf\u0131ndan belirlenen saatleri, dakikalar\u0131 ve saniyeleri kullanarak ge\u00e7erli bir zaman de\u011feri (VBA&#8217;ya g\u00f6re) d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/zaman-degeri\/\">VBA TIMEVALUE i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Tarih ve saati olan bir de\u011ferin zaman de\u011ferini al\u0131r ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><\/tbody><\/table><\/figure><h2 class=\"wp-block-heading\"> VBA MATEMAT\u0130K \u0130\u015flevleri<\/h2><p> VBA MATHS i\u015flevleri belirli matematiksel hesaplamalar\u0131 ger\u00e7ekle\u015ftirmek i\u00e7in tasarlanm\u0131\u015ft\u0131r. Basit\u00e7e s\u00f6ylemek gerekirse, bu i\u015flevler, ba\u015fka t\u00fcrl\u00fc ger\u00e7ekle\u015ftirilmesi karma\u015f\u0131k olan hesaplamalar\u0131 ger\u00e7ekle\u015ftirir.<\/p><p> A\u015fa\u011f\u0131da kullanmay\u0131 \u00f6\u011frenebilece\u011finiz 13 MATEMAT\u0130K fonksiyonunun bir listesi bulunmaktad\u0131r: <\/p><figure class=\"wp-block-table\"><table class=\"mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <strong>\u0130sim<\/strong><\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> <strong>Tan\u0131m<\/strong> <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/karin-kaslari-1\/\" data-wpil=\"url\">ABS VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Say\u0131sal bir de\u011feri mutlak say\u0131ya d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/atn\/\">ATN VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan say\u0131n\u0131n arktanjant\u0131n\u0131 hesaplar ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/cunku\/\">VBA COS i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan a\u00e7\u0131n\u0131n kosin\u00fcs\u00fcn\u00fc hesaplar ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/tecrube\/\">EXP VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan x de\u011feri i\u00e7in ex de\u011ferini hesaplar ve sonu\u00e7ta bunu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/duzeltmek\/\">VBA D\u00dcZELTME i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir tamsay\u0131y\u0131 kestikten sonra sonu\u00e7ta bir say\u0131 d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/int\/\">VBA INT i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir say\u0131 al\u0131r ve sonu\u00e7taki k\u0131sm\u0131n\u0131n tamam\u0131n\u0131 say\u0131 olarak d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/vba-gunlugu\/\">VBA G\u00dcNL\u00dcK i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Kullan\u0131c\u0131 taraf\u0131ndan do\u011fal logaritman\u0131n do\u011fal logaritmas\u0131n\u0131 hesaplar ve sonu\u00e7 olarak d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/rnd\/\">RND VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sonu\u00e7ta 0&#8217;dan 1&#8217;e kadar rastgele bir say\u0131 d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/yuvarlak\/\">VBA YUVARLAK i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir say\u0131y\u0131 belirli say\u0131da ondal\u0131k basama\u011fa yuvarlar ve sonu\u00e7ta yeni yuvarlanm\u0131\u015f say\u0131y\u0131 d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/isaret\/\">SGN VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan say\u0131n\u0131n aritmetik i\u015faretini temsil eden bir tam say\u0131 d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/gunah\/\">VBA SIN i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan a\u00e7\u0131n\u0131n sin\u00fcs\u00fcn\u00fc hesaplar ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/kare\/\">VBA SQR i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan say\u0131n\u0131n karek\u00f6k\u00fcn\u00fc hesaplar ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/bronzluk\/\">VBA TAN i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Verilen a\u00e7\u0131 de\u011ferinin tanjant\u0131n\u0131 hesaplar.<\/div><\/td><\/tr><\/tbody><\/table><\/figure><h2 class=\"wp-block-heading\"> VBA Mant\u0131ksal \u0130\u015flevleri<\/h2><p> VBA LOGICAL i\u015flevleri, ko\u015fullar\u0131 test etmenize ve bu ko\u015ful varsa bir de\u011feri, bu de\u011fer YANLI\u015e ise ba\u015fka bir de\u011feri d\u00f6nd\u00fcrmenize yard\u0131mc\u0131 olur.<\/p><p> A\u015fa\u011f\u0131da kullanmay\u0131 \u00f6\u011frenebilece\u011finiz 1 LOGIC fonksiyonumuz var ve VBA IF&#8217;yi kodlar\u0131n\u0131zda da kullanabilirsiniz: <\/p><figure class=\"wp-block-table\"><table class=\"mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <strong>\u0130sim<\/strong><\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> <strong>Tan\u0131m<\/strong> <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/eger\/\">VBA IIF \u0130\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir ko\u015fulu test eder ve ko\u015ful DO\u011eRU ise belirtilen de\u011feri, YANLI\u015e ise ba\u015fka bir (belirtilen) de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><\/tbody><\/table><\/figure><h2 class=\"wp-block-heading\"> VBA Bilgi \u0130\u015flevleri<\/h2><p> VBA B\u0130LG\u0130 i\u015flevleri, Excel uygulama ortam\u0131ndan belirli bilgileri alman\u0131za yard\u0131mc\u0131 olur. Bir de\u011ferin tarih olup olmad\u0131\u011f\u0131n\u0131, bir hata olup olmad\u0131\u011f\u0131n\u0131 veya bir nesneniz olup olmad\u0131\u011f\u0131n\u0131 kontrol edebilirsiniz.<\/p><p> A\u015fa\u011f\u0131da kullanmay\u0131 \u00f6\u011frenebilece\u011finiz 8 B\u0130LG\u0130 fonksiyonunun bir listesi bulunmaktad\u0131r: <\/p><figure class=\"wp-block-table\"><table class=\"mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <strong>\u0130sim<\/strong><\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> <strong>Tan\u0131m<\/strong> <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/dizi\/\">VBA ISARRAY i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadenin bir dizi olup olmad\u0131\u011f\u0131n\u0131 test eder ve sonucu DO\u011eRU veya YANLI\u015e olarak d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> VBA ISDATE i\u015flevi<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadenin tarih olup olmad\u0131\u011f\u0131n\u0131 test eder ve sonucu DO\u011eRU veya YANLI\u015e olarak d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/bos\/\">VBA ISEMPTY i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadenin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 test eder ve sonucu DO\u011eRU veya YANLI\u015e olarak d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/hata\/\">VBA i\u015flevi HATASI<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadenin hatal\u0131 olup olmad\u0131\u011f\u0131n\u0131 test eder ve sonucu DO\u011eRU veya YANLI\u015e olarak d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/kayip\/\">ISMISSING VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir prosed\u00fcr\u00fcn arg\u00fcman\u0131n\u0131n eksik olup olmad\u0131\u011f\u0131n\u0131 test eder ve sonucu DO\u011eRU veya YANLI\u015e olarak d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> VBA ISNULL i\u015flevi<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadenin NULL olup olmad\u0131\u011f\u0131n\u0131 test eder ve sonucu DO\u011eRU veya YANLI\u015e olarak d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/sayisal\/\">ISNUMERIC VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Verilen ifadenin say\u0131 olup olmad\u0131\u011f\u0131n\u0131 test eder ve sonucu DO\u011eRU veya YANLI\u015e olarak d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/es-nesne\/\">ISOOBJECT VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadenin bir nesne olup olmad\u0131\u011f\u0131n\u0131 test eder ve sonucu DO\u011eRU veya YANLI\u015e olarak d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><\/tbody><\/table><\/figure><h2 class=\"wp-block-heading\"> VBA mali i\u015flevleri<\/h2><p> VBA&#8217;n\u0131n finansal i\u015flevleri, girdi\u011finiz de\u011ferlerle finansal hesaplamalar yapman\u0131za yard\u0131mc\u0131 olur. Yat\u0131r\u0131mlar ve krediler i\u00e7in amortisman, gelecekteki de\u011ferler veya faiz oran\u0131n\u0131 hesaplayabilirsiniz.<\/p><p> A\u015fa\u011f\u0131da kullanmay\u0131 \u00f6\u011frenebilece\u011finiz 12 F\u0130NANSAL fonksiyonun bir listesi bulunmaktad\u0131r: <\/p><figure class=\"wp-block-table\"><table class=\"mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> \u0130sim<\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> <strong>Tan\u0131m<\/strong> <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/ddb\/\">VBA DDB \u0130\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir varl\u0131\u011f\u0131n belirli bir d\u00f6nem i\u00e7in amortisman\u0131n\u0131 \u00e7ift azalan bakiye y\u00f6ntemini kullanarak hesaplar.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/fv2\/\">FV VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir kredinin veya yat\u0131r\u0131m\u0131n gelecekteki de\u011ferini hesaplar.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/ipmt\/\">IPMT VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir kredinin veya yat\u0131r\u0131m\u0131n belirli bir d\u00f6neme ait faiz tutar\u0131n\u0131 hesaplar.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/kusura-bakma\/\">VBA IRR i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir dizi periyodik nakit ak\u0131\u015f\u0131 \u00fczerinden i\u00e7 getiri oran\u0131n\u0131 hesaplar.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/ayna\/\">VBA MIRR i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir dizi periyodik nakit ak\u0131\u015f\u0131 i\u00e7in de\u011fi\u015ftirilmi\u015f i\u00e7 getiri oran\u0131n\u0131 hesaplar.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/hayir\/\">VBA NPER i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir yat\u0131r\u0131m\u0131n veya kredinin d\u00f6nem say\u0131s\u0131n\u0131 hesaplar.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/npv\/\">VAN VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir yat\u0131r\u0131m\u0131n net bug\u00fcnk\u00fc de\u011ferini hesaplar.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/pmt-2\/\">VBA PMT i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Belirli bir d\u00f6neme ait bir kredinin veya yat\u0131r\u0131m\u0131n anapara tutar\u0131n\u0131 hesaplar.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/hp-2\/\">VBA fotovoltaik i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir kredinin veya yat\u0131r\u0131m\u0131n mevcut de\u011ferini hesaplar.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/kacirildi\/\">VBA ORANI i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir kredinin veya yat\u0131r\u0131m\u0131n faiz oran\u0131n\u0131 hesaplar.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/sln\/\">SLN VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir varl\u0131\u011f\u0131n tek bir d\u00f6nem i\u00e7in do\u011frusal amortisman\u0131n\u0131 hesaplar.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/syd\/\">VBA SYD i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir varl\u0131\u011f\u0131n \u00f6mr\u00fcn\u00fcn belirli bir d\u00f6nemi i\u00e7in y\u0131l rakamlar\u0131 toplam\u0131 cinsinden amortisman\u0131 hesaplar.<\/div><\/td><\/tr><\/tbody><\/table><\/figure><h2 class=\"wp-block-heading\"> VBA D\u0130Z\u0130S\u0130 \u0130\u015flevleri<\/h2><p> VBA ARRAYS i\u015flevleri dizileri y\u00f6netmenize yard\u0131mc\u0131 olur. Bir dizideki de\u011ferleri filtreleyebilir ve bir dizeyi birle\u015ftirip b\u00f6lebilirsiniz.<\/p><p> A\u015fa\u011f\u0131da kullanmay\u0131 \u00f6\u011frenebilece\u011finiz 6 ARRAY fonksiyonunun bir listesi bulunmaktad\u0131r: <\/p><figure class=\"wp-block-table\"><table class=\"mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <strong>\u0130sim<\/strong><\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> <strong>Tan\u0131m<\/strong> <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/dagitmak\/\">VBA dizi i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sizin taraf\u0131n\u0131zdan sa\u011flanan bir dizi de\u011ferden olu\u015fan bir dizi olu\u015fturur.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/filtre\/\">VBA F\u0130LTRE i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> \u00d6l\u00e7\u00fctleri kullanarak bir dize dizisinin alt k\u00fcmesini d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/katilmak\/\">VBA KATIL i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Birden \u00e7ok dizeyi bir dizede birle\u015ftirir ve sonu\u00e7 olarak onu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/sinir-disi\/\">VBA LBOUND i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir dizinin boyutu i\u00e7in en d\u00fc\u015f\u00fck endeksi d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/bolmek\/\">VBA B\u00d6LME i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Kullanarak bir dizeyi birden \u00e7ok dizeye b\u00f6ler.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/yukariya-dogru\/\">VBA UBOUND i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir dizinin boyutunun \u00fcst dizinini d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><\/tbody><\/table><\/figure><h2 class=\"wp-block-heading\"> VBA Veri T\u00fcr\u00fc D\u00f6n\u00fc\u015ft\u00fcrme \u0130\u015flevleri<\/h2><p> VBA Veri T\u00fcr\u00fc D\u00f6n\u00fc\u015ft\u00fcrme \u0130\u015flevleri, metin olarak depolanan bir say\u0131y\u0131 uzun bir veri t\u00fcr\u00fcne d\u00f6n\u00fc\u015ft\u00fcrmek gibi, bir de\u011feri bir veri t\u00fcr\u00fcnden ba\u015fka bir veri t\u00fcr\u00fcne d\u00f6n\u00fc\u015ft\u00fcrmenize yard\u0131mc\u0131 olur.<\/p><p> A\u015fa\u011f\u0131da 20 D\u00f6n\u00fc\u015f\u00fcm veri t\u00fcr\u00fcn\u00fcn bir listesi bulunmaktad\u0131r. Kullanmay\u0131 \u00f6\u011frenebilece\u011finiz \u00f6zellikler: <\/p><figure class=\"wp-block-table\"><table class=\"mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> \u0130sim<\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> <strong>Tan\u0131m<\/strong> <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/bool\/\">VBA CBOOL i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadeyi Boolean veri de\u011ferine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve sonu\u00e7ta onu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/cbyte\/\">VBA CBYTE i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadeyi bayt veri de\u011ferine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/meydana\/\">VBA CCUR i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadeyi ge\u00e7erli veri de\u011ferine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih\/\">CDATE VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadeyi tarih verisi de\u011ferine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/cdbl\/\">VBA CDBL i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadeyi double veri de\u011ferine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/cdec\/\">VBA CDEC i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadeyi ondal\u0131k veri de\u011ferine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/saat\/\">VBA CHR i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan karakter kodunu kullanarak karakteri d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/biraz\/\">VBA CINT i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadeyi tamsay\u0131 veri de\u011ferine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/sarilmak\/\">VBA CLNG i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadeyi uzun bir veri de\u011ferine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/csng\/\">VBA CSNG i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadeyi tek bir veri de\u011ferine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/cstr\/\">VBA CSTR i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadeyi dize veri de\u011ferine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/cvar\/\">CVAR VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadeyi bir de\u011fi\u015fken veri de\u011ferine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/bicim-para-birimi\/\">VBA FORMAT AKIM i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Para birimi bi\u00e7imini sa\u011flanan ifadeye uygular ve sonu\u00e7ta onu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/formattarihsaat\/\">VBA FORMATDATETIME i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Tarih bi\u00e7imini sa\u011flanan ifadeye uygular ve sonu\u00e7ta onu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/format-numarasi\/\">VBA FORMATNUMBER i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan ifadeye say\u0131 bi\u00e7imini uygular ve sonu\u00e7ta onu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/format-yuzdesi\/\">VBA FORMATPERCENT i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Y\u00fczde bi\u00e7imini sa\u011flanan ifadeye uygular ve sonu\u00e7ta onu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/altigen\/\">HEX VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Say\u0131sal bir de\u011feri onalt\u0131l\u0131k g\u00f6sterime d\u00f6n\u00fc\u015ft\u00fcrerek bir dize d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/ekim\/\">OCT VBA i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Say\u0131sal bir de\u011feri sekizli g\u00f6sterime d\u00f6n\u00fc\u015ft\u00fcrerek bir dize d\u00f6nd\u00fcr\u00fcr<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/cadde\/\">VBA STR i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Say\u0131sal bir de\u011feri dizeye d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve sonucu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/val\/\">VBAVAL i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Bir dizeyi say\u0131sal bir de\u011fere d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve sonu\u00e7ta onu d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><\/tbody><\/table><\/figure><h2 class=\"wp-block-heading\"> VBA Hata \u0130\u015fleme \u0130\u015flevleri<\/h2><p> VBA hata i\u015fleme i\u015flevleri, VBA kodunda olu\u015fan hata hakk\u0131nda bilgi alman\u0131za yard\u0131mc\u0131 olur. A\u015fa\u011f\u0131da kullanmay\u0131 \u00f6\u011frenebilece\u011finiz 1 hata i\u015fleme fonksiyonumuz var ve kodlar\u0131n\u0131zda hata i\u015fleme tekniklerini de kullanabilirsiniz: <\/p><figure class=\"wp-block-table\"><table class=\"mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <strong>\u0130sim<\/strong><\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> <strong>Tan\u0131m<\/strong> <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Name\"><div class=\"mtr-cell-content\"> <a href=\"https:\/\/exceladvisor.org\/tr\/cverr\/\">VBA CVERR i\u015flevi<\/a><\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Sa\u011flanan hata veri numaras\u0131n\u0131 kullanarak bir hata veri t\u00fcr\u00fc d\u00f6nd\u00fcr\u00fcr.<\/div><\/td><\/tr><\/tbody><\/table><\/figure>","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-1518","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 VBA \u0130\u015flevleri: Excel Dan\u0131\u015fman\u0131ndan \u00d6rnekler + Kodlar<\/title>\n<meta name=\"description\" content=\"bu y\u00fczden burada en iyi 100 VBA (Kategori Bilgesi) i\u015flevini \u00f6rnekler ve \u00f6rnek kodlarla ayr\u0131nt\u0131l\u0131 olarak listeledim ve bunlar\" \/>\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\/islevler\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 VBA \u0130\u015flevleri: Excel Dan\u0131\u015fman\u0131ndan \u00d6rnekler + Kodlar\" \/>\n<meta property=\"og:description\" content=\"bu y\u00fczden burada en iyi 100 VBA (Kategori Bilgesi) i\u015flevini \u00f6rnekler ve \u00f6rnek kodlarla ayr\u0131nt\u0131l\u0131 olarak listeledim ve bunlar\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/islevler\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:58:36+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=\"14 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/islevler\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/islevler\/\",\"name\":\"\u25b7 VBA \u0130\u015flevleri: Excel Dan\u0131\u015fman\u0131ndan \u00d6rnekler + Kodlar\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"datePublished\":\"2023-11-18T03:01:29+00:00\",\"dateModified\":\"2023-12-10T05:58:36+00:00\",\"description\":\"bu y\u00fczden burada en iyi 100 VBA (Kategori Bilgesi) i\u015flevini \u00f6rnekler ve \u00f6rnek kodlarla ayr\u0131nt\u0131l\u0131 olarak listeledim ve bunlar\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/islevler\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/islevler\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/islevler\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ana vba i\u015flevleri\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 VBA \u0130\u015flevleri: Excel Dan\u0131\u015fman\u0131ndan \u00d6rnekler + Kodlar","description":"bu y\u00fczden burada en iyi 100 VBA (Kategori Bilgesi) i\u015flevini \u00f6rnekler ve \u00f6rnek kodlarla ayr\u0131nt\u0131l\u0131 olarak listeledim ve bunlar","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\/islevler\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 VBA \u0130\u015flevleri: Excel Dan\u0131\u015fman\u0131ndan \u00d6rnekler + Kodlar","og_description":"bu y\u00fczden burada en iyi 100 VBA (Kategori Bilgesi) i\u015flevini \u00f6rnekler ve \u00f6rnek kodlarla ayr\u0131nt\u0131l\u0131 olarak listeledim ve bunlar","og_url":"https:\/\/exceladvisor.org\/tr\/islevler\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:58:36+00:00","twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"14 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/islevler\/","url":"https:\/\/exceladvisor.org\/tr\/islevler\/","name":"\u25b7 VBA \u0130\u015flevleri: Excel Dan\u0131\u015fman\u0131ndan \u00d6rnekler + Kodlar","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"datePublished":"2023-11-18T03:01:29+00:00","dateModified":"2023-12-10T05:58:36+00:00","description":"bu y\u00fczden burada en iyi 100 VBA (Kategori Bilgesi) i\u015flevini \u00f6rnekler ve \u00f6rnek kodlarla ayr\u0131nt\u0131l\u0131 olarak listeledim ve bunlar","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/islevler\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/islevler\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/islevler\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Ana vba i\u015flevleri"}]},{"@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\/1518","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=1518"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1518\/revisions"}],"predecessor-version":[{"id":2256,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1518\/revisions\/2256"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1518"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}