{"id":1863,"date":"2023-10-30T18:34:26","date_gmt":"2023-10-30T18:34:26","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/"},"modified":"2023-12-10T06:07:48","modified_gmt":"2023-12-10T06:07:48","slug":"kullanici-tanimli-fonksiyon-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/","title":{"rendered":"Vba&#39;da kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flev nas\u0131l olu\u015fturulur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2894385413\"><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>Muhtemelen VBA \u00f6\u011frenmenin en harika faydalar\u0131ndan biri kendi i\u015flevlerinizi yaratma yetene\u011fidir.<\/p><p> Excel&#8217;de 450&#8217;den fazla i\u015flev vard\u0131r ve bunlardan baz\u0131lar\u0131 g\u00fcnl\u00fck i\u015flerinizde \u00e7ok faydal\u0131d\u0131r. Ancak Excel size VBA&#8217;y\u0131 kullanarak \u00f6zel bir i\u015flev olu\u015fturma se\u00e7ene\u011fi sunar. Evet hakl\u0131s\u0131n. KULLANICI TANIMLI \u0130\u015flev, UDF olarak k\u0131salt\u0131l\u0131r veya buna \u00f6zel bir VBA i\u015flevi de diyebilirsiniz.<\/p><p> Ve g\u00fcvenle s\u00f6yleyebilece\u011fim bir \u015fey var ki, her yeni ba\u015flayan VBA kullan\u0131c\u0131s\u0131, kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flevin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 \u00f6\u011frenmek ister. Sen de\u011fil? \u00d6zel bir \u00f6zellik olu\u015fturmak isteyen ki\u015filerden biriyseniz, yorumlar b\u00f6l\u00fcm\u00fcnde \u201cEvet\u201d deyin.<\/p><p> Bunun, VBA kullanarak ilk \u00f6zel i\u015flevinizi olu\u015fturman\u0131za yard\u0131mc\u0131 olacak TAM bir KILAVUZ oldu\u011funu s\u00f6ylemekten mutluluk duyuyorum ve bunun d\u0131\u015f\u0131nda, size ilham vermek i\u00e7in KULLANICI TANIMLI \u0130\u015eLEVLER&#8217;in baz\u0131 \u00f6rneklerini payla\u015ft\u0131m.<\/p><ol><li> Burada kullan\u0131c\u0131 tan\u0131ml\u0131 fonksiyon, \u00f6zel fonksiyon ve UDF kelimelerini birbirinin yerine kullanaca\u011f\u0131m. O y\u00fczden benimle kal, \u00f6n\u00fcm\u00fczdeki birka\u00e7 dakika i\u00e7inde VBA rock y\u0131ld\u0131z\u0131 olacaks\u0131n.<\/li><li> VBA \u00f6zel i\u015flevine y\u00f6nelik kod olu\u015fturmak i\u00e7in onu yazman\u0131z gerekir, <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/\" data-wpel-link=\"internal\">makro kaydediciyi kullanarak kaydedemezsiniz<\/a> .<\/li><\/ol><h2 class=\"wp-block-heading\"> Neden \u00f6zel bir Excel i\u015flevi olu\u015fturmal\u0131s\u0131n\u0131z?<\/h2><p> S\u00f6yledi\u011fim gibi <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/\" data-wpel-link=\"internal\">Excel&#8217;de hemen hemen her sorunu \u00e7\u00f6zmenize ve her t\u00fcrl\u00fc hesaplamay\u0131 yapman\u0131za yard\u0131mc\u0131 olabilecek bir\u00e7ok yerle\u015fik i\u015flev<\/a> vard\u0131r. Ancak bazen belirli durumlarda bir UDF olu\u015fturman\u0131z gerekir.<\/p><p> A\u015fa\u011f\u0131da \u00f6zel bir i\u015flevi kullanman\u0131z gereken baz\u0131 nedenleri veya durumlar\u0131 listeledim.<\/p><h3 class=\"wp-block-heading\"> 1. Bunun i\u00e7in bir i\u015flev olmad\u0131\u011f\u0131nda<\/h3><p> Bu, VBA ile UDF olu\u015fturman\u0131n yayg\u0131n nedenlerinden biridir, \u00e7\u00fcnk\u00fc bazen bir \u015feyi hesaplaman\u0131z gerekir ve bunun i\u00e7in \u00f6zel bir i\u015flev yoktur. Size <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/kelimeleri-say\/\" data-wpel-link=\"internal\">bir h\u00fccreden kelime sayma<\/a> \u00f6rne\u011fi verebilirim ve bunun i\u00e7in UDF&#8217;nin m\u00fckemmel bir \u00e7\u00f6z\u00fcm olabilece\u011fini buldum. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-le-mot-udf-pour-savoir-pourquoi-la-creation-dune-fonction-personnalisee-est-importante-1.png\" sizes=\"\" srcset=\"\" alt=\"\u00f6zel bir i\u015flev olu\u015fturman\u0131n neden \u00f6nemli oldu\u011funu bilmek i\u00e7in udf kelimesini say\u0131n\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 2. Karma\u015f\u0131k bir form\u00fcl\u00fc de\u011fi\u015ftirin<\/h3><p> Form\u00fcllerle \u00e7al\u0131\u015f\u0131yorsan\u0131z, karma\u015f\u0131k form\u00fcllerin okunmas\u0131n\u0131n zor oldu\u011funu ve bazen ba\u015fkalar\u0131 i\u00e7in anla\u015f\u0131lmas\u0131n\u0131n daha zor oldu\u011funu bildi\u011finizden eminim. Dolay\u0131s\u0131yla, \u00f6zel bir i\u015flev bu soruna bir \u00e7\u00f6z\u00fcm olabilir \u00e7\u00fcnk\u00fc bir UDF olu\u015fturdu\u011funuzda bu karma\u015f\u0131k form\u00fcl\u00fc tekrar tekrar yazman\u0131za gerek kalmaz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-fonction-definie-par-lutilisateur-peut-vous-aider-a-eviter-de-longs-calculs-1.png\" sizes=\"\" srcset=\"\" alt=\"kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flev uzun hesaplamalardan ka\u00e7\u0131nman\u0131za yard\u0131mc\u0131 olabilir\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 3. SUB Rutinini kullanmak istemedi\u011finizde<\/h3><p> Hesaplama yapmak i\u00e7in VBA kodunu kullanabilseniz de VBA kodlar\u0131 dinamik de\u011fildir*. Hesaplaman\u0131z\u0131 g\u00fcncellemek istiyorsan\u0131z bu kodu tekrar \u00e7al\u0131\u015ft\u0131rman\u0131z gerekir. Ancak bu kodu fonksiyona d\u00f6n\u00fc\u015ft\u00fcr\u00fcrseniz, bu kodu tekrar tekrar \u00e7al\u0131\u015ft\u0131rman\u0131za gerek kalmaz \u00e7\u00fcnk\u00fc onu sadece fonksiyon olarak ekleyebilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Excel&#8217;de \u0130lk Kullan\u0131c\u0131 Tan\u0131ml\u0131 \u0130\u015flevinizi Nas\u0131l Olu\u015fturabilirsiniz?<\/h2><p> Tamam o zaman bak. T\u00fcm s\u00fcreci \u00fc\u00e7 ad\u0131ma ay\u0131rd\u0131m:<\/p><ol><li> Prosed\u00fcr\u00fcn\u00fcz\u00fc bir fonksiyon olarak bildirin<\/li><li> Ba\u011f\u0131ms\u0131z de\u011fi\u015fkenlerini ve veri t\u00fcrlerini tan\u0131mlay\u0131n<\/li><li> \u0130stenilen de\u011feri hesaplamak i\u00e7in kod ekleyin<\/li><\/ol><p> Ama sana \u015funu s\u00f6yleyeyim:<\/p><p> Tarih de\u011ferinden g\u00fcn ad\u0131n\u0131 d\u00f6nd\u00fcrebilecek bir fonksiyon olu\u015fturman\u0131z gerekiyor. Haftan\u0131n g\u00fcn\u00fcn\u00fc d\u00f6nd\u00fcren ancak ad\u0131 d\u00f6nd\u00fcrmeyen bir fonksiyonumuz var. Ne dedi\u011fimi anl\u0131yor musun? Evet?<\/p><p> \u015eimdi ilk kullan\u0131c\u0131 tan\u0131ml\u0131 fonksiyonunuzu olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyelim:<\/p><ol><li> \u00d6ncelikle ALT + F11 k\u0131sayol tu\u015funu kullanarak <a href=\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/\" data-wpel-link=\"internal\">Visual Basic edit\u00f6r\u00fcn\u00fcz\u00fc<\/a> a\u00e7\u0131n veya <a href=\"https:\/\/exceladvisor.org\/tr\/gelistirici-sekmesi-ekle\/\" data-wpel-link=\"internal\">Geli\u015ftirici sekmesine<\/a> gidin ve \u201cVisual Basic\u201d butonuna t\u0131klaman\u0131z yeterlidir. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-lediteur-vb-pour-ecrire-du-code-pour-udf-1.png\" sizes=\"\" srcset=\"\" alt=\"udf kodunu yazmak i\u00e7in vb edit\u00f6r\u00fcn\u00fc a\u00e7\u0131n\"><\/li><li> Bir sonraki \u015fey bir mod\u00fcl eklemektir, bu nedenle VBA proje penceresine sa\u011f t\u0131klay\u0131n, ard\u0131ndan eklemeye gidin ve ard\u0131ndan &#8220;Mod\u00fcl&#8221; e t\u0131klay\u0131n. (UYARI: Yaln\u0131zca standart mod\u00fcllerde KULLANICI TANIMLI \u0130\u015eLEV girmelisiniz. Hem Sayfa hem de ThisWorkbook mod\u00fclleri \u00f6zel bir mod\u00fcl t\u00fcr\u00fcd\u00fcr ve bu iki mod\u00fcle UDF girerseniz Excel, UDF olu\u015fturdu\u011funuzu alg\u0131lamaz) . <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-module-dans-lediteur-vba-pour-ecrire-un-udf-1.png\" sizes=\"\" srcset=\"\" alt=\"udf yazmak i\u00e7in vba d\u00fczenleyicisine bir mod\u00fcl ekleyin\"><\/li><li> \u00dc\u00e7\u00fcnc\u00fcs\u00fc ise fonksiyona isim belirlemek ve burada \u201cmyDayName\u201d kullan\u0131yorum. Bu y\u00fczden \u201cFunction mydayName\u201d yazman\u0131z gerekiyor. Neden \u0130simden \u00d6nce \u0130\u015flev? Bir VBA i\u015flevi olu\u015fturdu\u011funuzda, &#8220;\u0130\u015flev&#8221; s\u00f6zc\u00fc\u011f\u00fcn\u00fc kullanmak Excel&#8217;e bu kodu bir i\u015flev olarak ele almas\u0131n\u0131 s\u00f6yler (mesajdan \u00f6nce UDF&#8217;nin kapsam\u0131n\u0131 okudu\u011funuzdan emin olun). <img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ecrire-un-nom-de-la-fonction-vba-personnalisee-1.png\" sizes=\"\" srcset=\"\" alt=\"\u00f6zel bir vba i\u015flev ad\u0131 yaz\u0131n\"><\/li><li> Bundan sonra fonksiyonunuz i\u00e7in arg\u00fcmanlar\u0131 tan\u0131mlaman\u0131z gerekir. Bu y\u00fczden \u00f6n parantezleri ekleyin ve \u201cInputDate As Date\u201d yaz\u0131n. Burada, OutputDate ba\u011f\u0131ms\u0131z de\u011fi\u015fkenin ad\u0131d\u0131r ve tarih ise veri t\u00fcr\u00fcd\u00fcr. Ba\u011f\u0131ms\u0131z de\u011fi\u015fken i\u00e7in bir veri t\u00fcr\u00fc tan\u0131mlamak her zaman en iyisidir. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/letape-suivante-pour-ajouter-un-argument-a-la-fonction-definie-par-lutilisateur-1.png\" sizes=\"\" srcset=\"\" alt=\"kullan\u0131c\u0131 tan\u0131ml\u0131 fonksiyona arg\u00fcman eklemek i\u00e7in sonraki ad\u0131m\"><\/li><li> \u015eimdi parantezleri kapat\u0131n ve \u201cAs String\u201d yaz\u0131n. Burada fonksiyonun d\u00f6nd\u00fcrd\u00fc\u011f\u00fc sonucun veri tipini ve g\u00fcn\u00fcn ismini istedi\u011finiz gibi tan\u0131ml\u0131yorsunuz, dolay\u0131s\u0131yla veri tipinin \u201cString\u201d olmas\u0131 gerekiyor. Sonucun dize d\u0131\u015f\u0131nda bir \u015fey olmas\u0131n\u0131 istiyorsan\u0131z veri t\u00fcr\u00fcn\u00fc buna g\u00f6re ayarlad\u0131\u011f\u0131n\u0131zdan emin olun. (myDayName(InputDate As Date) As String i\u015flevi). <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/apres-cela-definissez-le-type-de-donnees-pour-lUDF-1.png\" sizes=\"\" srcset=\"\" alt=\"bundan sonra UDF i\u00e7in veri t\u00fcr\u00fcn\u00fc ayarlay\u0131n\"><\/li><li> Sonunda ENTER&#8217;a bas\u0131n. Bu noktada fonksiyon ad\u0131n\u0131z, arg\u00fcman\u0131, arg\u00fcman veri tipi ve fonksiyon veri tipi ayarland\u0131 ve mod\u00fcl\u00fcn\u00fczde a\u015fa\u011f\u0131dakine benzer bir \u015fey var: <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/fonction-personnalisee-vba-apres-avoir-defini-les-arguments-de-nom-1.png\" sizes=\"\" srcset=\"\" alt=\"ad ba\u011f\u0131ms\u0131z de\u011fi\u015fkenlerini ayarlad\u0131ktan sonra vba \u00f6zel i\u015flevi\"><\/li><li> \u015eimdi \u201cFonksiyon\u201d ve \u201cSon Fonksiyon\u201dda hesaplamay\u0131 tan\u0131mlaman\u0131z gerekiyor veya bu UDF&#8217;nin \u00e7al\u0131\u015fmas\u0131n\u0131 s\u00f6yleyebilirsiniz. Excel\u2019de \u201cMetin\u201d diye bir \u00e7al\u0131\u015fma sayfas\u0131 fonksiyonu var ve biz de ayn\u0131s\u0131n\u0131 burada kullan\u0131yoruz. Bunun i\u00e7in de a\u015fa\u011f\u0131daki kodu yazman\u0131z gerekiyor ve bu kodla fonksiyonun d\u00f6nd\u00fcrmesi gereken de\u011feri tan\u0131ml\u0131yorsunuz. myDayName = WorksheetFunction.Text(InputDate, &#8220;dddddd&#8221;) <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/apres-avoir-ecrit-le-code-a-utiliser-dans-la-fonction-personnalisee-vba-1-1.png\" sizes=\"\" srcset=\"\" alt=\"vba \u00f6zel i\u015flevinde kullan\u0131lacak kodu yazd\u0131ktan sonra\"><\/li><li> \u015eimdi VB d\u00fczenleyicinizi kapat\u0131n ve \u00e7al\u0131\u015fma sayfas\u0131na geri d\u00f6n\u00fcn ve B2 h\u00fccresine \u201c=myDayName(A2)\u201d yaz\u0131n ve Enter tu\u015funa bas\u0131n; g\u00fcn\u00fcn ad\u0131n\u0131 alacaks\u0131n\u0131z. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserez-votre-fonction-vba-personnalisee-dans-la-feuille-de-calcul-1.png\" sizes=\"\" srcset=\"\" alt=\"\u00f6zel vba i\u015flevinizi \u00e7al\u0131\u015fma sayfas\u0131na ekleyin\"><\/li><\/ol><p> Tebrikler! \u0130lk kullan\u0131c\u0131 tan\u0131ml\u0131 fonksiyonunuzu yeni yaratt\u0131n\u0131z. Bu ger\u00e7ek Sevincin zaman\u0131d\u0131r. De\u011fil mi? Yorumlar k\u0131sm\u0131na \u201cSevin\u00e7\u201d yaz\u0131n.<\/p><h3 class=\"wp-block-heading\"> Bu i\u015flev nas\u0131l \u00e7al\u0131\u015f\u0131r ve h\u00fccrede de\u011fer d\u00f6nd\u00fcrme<\/h3><p> \u0130lk \u00f6zel i\u015fleviniz burada, ancak \u00f6nemli olan bunun nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 anlaman\u0131z gerekti\u011fidir. Basit\u00e7e s\u00f6ylersem bu VBA kodudur ama siz bunu fonksiyon prosed\u00fcr\u00fc olarak kulland\u0131n\u0131z. \u00dc\u00e7 par\u00e7aya b\u00f6lelim:<\/p><ul><li> Bunu bir h\u00fccreye fonksiyon olarak girersiniz ve giri\u015f de\u011ferini belirtirsiniz.<\/li><li> Excel, i\u015flevin arkas\u0131ndaki kodu \u00e7al\u0131\u015ft\u0131r\u0131r ve ba\u015fvurdu\u011funuz de\u011feri kullan\u0131r.<\/li><li> Sonu\u00e7 h\u00fccrede var.<\/li><\/ul><p> Ancak bu i\u015flevin i\u00e7eriden nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 anlamal\u0131s\u0131n\u0131z. Bu y\u00fczden t\u00fcm s\u00fcreci, fonksiyon i\u00e7in yazd\u0131\u011f\u0131n\u0131z kodun ger\u00e7ekte nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 g\u00f6rebilece\u011finiz \u00fc\u00e7 farkl\u0131 par\u00e7aya b\u00f6ld\u00fcm. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" title=\"kullan\u0131c\u0131 tan\u0131ml\u0131 fonksiyon\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/fonction-definie-par-lutilisateur.png\" sizes=\"\" srcset=\"\" alt=\"working-user-defined-function\"><\/figure><\/div><p> \u0130\u015flev arg\u00fcman\u0131 olarak &#8220;InputDate&#8221; belirtti\u011finiz i\u00e7in ve h\u00fccreye i\u015flevi girip tarih belirtti\u011finizde VBA bu tarih de\u011ferini al\u0131r ve kodda kulland\u0131\u011f\u0131n\u0131z metin i\u015flevine sa\u011flar.<\/p><p> Yukar\u0131da bahsetti\u011fim \u00f6rnekte ise A1 h\u00fccresindeki tarih 01-Ocak-2019.<\/p><p> Daha sonra TEXT fonksiyonu bu tarihi, fonksiyon kodunda belirtti\u011finiz \u201cdddddd\u201d format kodunu kullanarak bir g\u00fcne \u00e7evirir. TEXT fonksiyonunun d\u00f6nd\u00fcrd\u00fc\u011f\u00fc bu g\u00fcn ise \u201cmyDayName\u201de atan\u0131r.<\/p><p> Yani TEXT fonksiyonunun sonucu Sal\u0131 ise bu de\u011fer \u201cmyDayName\u201de atanacakt\u0131r.<\/p><p> Ve burada fonksiyonun i\u015fleyi\u015fi sona eriyor. &#8220;myDayName&#8221; i\u015flev ad\u0131d\u0131r, dolay\u0131s\u0131yla &#8220;myDayName&#8221;e atanan herhangi bir de\u011fer sonu\u00e7 de\u011feri olacakt\u0131r ve \u00e7al\u0131\u015fma sayfas\u0131na ekledi\u011finiz i\u015flev onu h\u00fccreye d\u00f6nd\u00fcrecektir.<\/p><p> \u00d6zel bir i\u015flev i\u00e7in kod <strong><span style=\"color: #ff0000;\">yazarken<\/span><\/strong> , o kodun d\u00f6nd\u00fcrd\u00fc\u011f\u00fc de\u011ferin i\u015flev ad\u0131na atand\u0131\u011f\u0131ndan emin olmal\u0131s\u0131n\u0131z.<\/p><h3 class=\"wp-block-heading\"> \u0130yilik \u0130\u00e7in Bir UDF Nas\u0131l Geli\u015ftirilir?<\/h3><p> \u00d6zel bir VBA i\u015flevinin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 biliyorsunuz.<\/p><p> \u015e\u0130MD\u0130\u2026<\/p><p> \u00c7al\u0131\u015ft\u0131\u011f\u0131n\u0131z kodun t\u00fcm olas\u0131l\u0131klar\u0131 kar\u015f\u0131layacak kadar iyi oldu\u011fundan emin olman\u0131z gereken bir \u015fey var. E\u011fer yukar\u0131da yazd\u0131\u011f\u0131n\u0131z fonksiyondan bahsediyorsan\u0131z bir tarihten g\u00fcn ad\u0131n\u0131 d\u00f6nd\u00fcrebilirsiniz.<\/p><p> Ama\u00e7\u2026<\/p><p> Peki ya belirtti\u011finiz de\u011fer bir tarih de\u011filse? Bahsetti\u011finiz h\u00fccre bo\u015fsa ne olur? Ba\u015fka olas\u0131l\u0131klar da olabilir ama demek istedi\u011fimi anlad\u0131\u011f\u0131n\u0131za eminim.<\/p><p> SA\u011e? \u00d6yleyse yukar\u0131daki sorunlar\u0131 \u00e7\u00f6zebilecek bu \u00f6zel i\u015flevi geli\u015ftirmeye \u00e7al\u0131\u015fal\u0131m. \u0130Y\u0130. \u00d6ncelikle arg\u00fcman\u0131n veri t\u00fcr\u00fcn\u00fc de\u011fi\u015ftirmeniz ve kullanman\u0131z gerekir:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">InputDate As Variant<\/code><\/pre><p> Bununla, \u00f6zel i\u015fleviniz her t\u00fcrl\u00fc veriyi girdi olarak alabilir. Daha sonra, belirli ko\u015fullar i\u00e7in OutputDate&#8217;i kontrol etmek \u00fczere <a href=\"https:\/\/exceladvisor.org\/tr\/eger-2\/\" data-wpel-link=\"internal\">VBA IF ifadesini<\/a> kullanmam\u0131z gerekir. \u0130lk ko\u015ful h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131d\u0131r. Ve bunun i\u00e7in a\u015fa\u011f\u0131daki kodu kullanmal\u0131s\u0131n\u0131z:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">If InputDate = \"\" Then myDayName = \"\"<\/code><\/pre><p> Ba\u015fvuruda bulundu\u011funuz h\u00fccre bo\u015fsa bu, i\u015flevi bo\u015f hale getirecektir.<\/p><p> Bir sorun \u00e7\u00f6z\u00fcld\u00fc, di\u011ferine ge\u00e7elim. Tarihin yan\u0131 s\u0131ra bir numara veya metin de olabilir. Dolay\u0131s\u0131yla bunun i\u00e7in ba\u015fvurulan de\u011ferin ger\u00e7ek bir tarih olup olmad\u0131\u011f\u0131n\u0131 kontrol edecek bir ko\u015ful da olu\u015fturman\u0131z gerekir.<\/p><p> Kod \u015f\u00f6yle olacakt\u0131r:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">If IsDate(InputDate) = False Then myDateName = \"\"<\/code><\/pre><p class=\"grey-note\"> Burada her iki ko\u015ful i\u00e7in de bo\u015fluk kullan\u0131yorum, b\u00f6ylece b\u00fcy\u00fck verileriniz varsa, giri\u015f de\u011ferinin ge\u00e7erli olmad\u0131\u011f\u0131 de\u011ferleri kolayca filtreleyebilirsiniz. Yukar\u0131daki ko\u015fullar\u0131 ekledikten sonra kod \u015f\u00f6yle g\u00f6r\u00fcnecektir:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Function myDayName(InputDate As Variant) As String If InputDate = \"\" Then myDayName = \"\" Else If IsDate(InputDate) = False Then myDateName = \"\" Else myDayName = WorksheetFunction.Text(InputDate, \"dddddd\") End If End If End Function<\/code><\/pre><p> Ve \u015fu anda i\u015fleyi\u015f \u015fekli \u015fu \u015fekilde: Bu \u00f6zellik \u00fczerinde h\u00e2l\u00e2 de\u011fi\u015fiklik yapabilece\u011finize eminim, ancak demek istedi\u011fimi a\u00e7\u0131k\u00e7a anlad\u0131\u011f\u0131n\u0131za eminim.<\/p><h2 class=\"wp-block-heading\"> \u00d6zel bir VBA i\u015flevi nas\u0131l kullan\u0131l\u0131r?<\/h2><p> Bu noktada Excel&#8217;de VBA fonksiyonunun nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 kabaca biliyorsunuz. Ancak bir kez sahip oldu\u011funuzda, onu nas\u0131l kullanabilece\u011finizi bilmeniz gerekir. Yaz\u0131n\u0131n bu k\u0131sm\u0131nda ise nas\u0131l ve nerede kullanabilece\u011finizi sizlerle payla\u015faca\u011f\u0131m. O halde hadi i\u00e7eri girelim.<\/p><h3 class=\"wp-block-heading\"> 1. Basit\u00e7e bir e-tabloda<\/h3><p> Neden \u00f6zel bir i\u015flev yarat\u0131yoruz? Basit. Elektronik tabloda kullanmak i\u00e7in. E\u015fittir i\u015faretini ve i\u015flevin t\u00fcr ad\u0131n\u0131 kullanarak bir UDF&#8217;yi bir e-tabloya kolayca girebilir, ard\u0131ndan ba\u011f\u0131ms\u0131z de\u011fi\u015fkenlerini belirtebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-fonction-personnalisee-dans-une-feuille-de-calcul-en-tapant-1.png\" sizes=\"\" srcset=\"\" alt=\"yazarak bir e-tabloya \u00f6zel bir i\u015flev ekleyin\"><\/figure><\/div><p> Ayr\u0131ca, i\u015flev kitapl\u0131\u011f\u0131ndan kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flevi de girebilirsiniz. Form\u00fcl sekmesine gidin \u279c \u0130\u015flev Ekle \u279c Kullan\u0131c\u0131 Tan\u0131ml\u0131. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-une-fonction-personnalisee-dans-une-feuille-de-calcul-a-partir-dune-formule-1.png\" sizes=\"\" srcset=\"\" alt=\"form\u00fclden \u00e7al\u0131\u015fma sayfas\u0131na \u00f6zel i\u015flev ekleme\"><\/figure><\/div><p> Bu listeden eklemek istedi\u011finiz UDF&#8217;yi se\u00e7ebilirsiniz.<\/p><h3 class=\"wp-block-heading\"> 2. Di\u011fer alt prosed\u00fcrleri ve i\u015flevleri kullanma<\/h3><p> Bir i\u015flevi di\u011fer i\u015flevler i\u00e7inde veya bir &#8220;Alt&#8221; prosed\u00fcrde de kullanabilirsiniz. A\u015fa\u011f\u0131da, ge\u00e7erli tarihin g\u00fcn ad\u0131n\u0131 almak i\u00e7in i\u015flevi kulland\u0131\u011f\u0131n\u0131z bir VBA kodu bulunmaktad\u0131r.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub todayDay() MsgBox \"Today is \" &amp; myDayName(Date) End Sub<\/code><\/pre><p class=\"grey-note\"> Bir i\u015flevi di\u011fer prosed\u00fcrlerde kullanma hakk\u0131nda daha fazla bilgi edinmek i\u00e7in bu makalenin ilerleyen k\u0131s\u0131mlar\u0131ndaki &#8220;UDF&#8217;nin Kapsam\u0131&#8221; b\u00f6l\u00fcm\u00fcn\u00fc mutlaka okuyun.<\/p><h3 class=\"wp-block-heading\"> 3. Ba\u015fka bir \u00e7al\u0131\u015fma kitab\u0131ndaki i\u015flevlere eri\u015fin<\/h3><p> Bir \u00e7al\u0131\u015fma kitab\u0131nda UDF&#8217;niz varsa ve bunu ba\u015fka bir \u00e7al\u0131\u015fma kitab\u0131nda veya t\u00fcm \u00e7al\u0131\u015fma kitaplar\u0131nda kullanmak istiyorsan\u0131z, bunun i\u00e7in bir eklenti olu\u015fturarak bunu yapabilirsiniz. \u015eu basit ad\u0131mlar\u0131 izleyin:<\/p><ul><li> \u00d6ncelikle, (\u00f6zel i\u015flev kodunun bulundu\u011fu) dosyay\u0131 eklenti olarak kaydetmeniz gerekir.<\/li><li> Bunu yapmak i\u00e7in Dosya sekmesine gidin \u279c Farkl\u0131 kaydet \u279c \u201cExcel Eklentileri (.xalm). <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/enregistrer-le-fichier-en-tant-que-complement-pour-utiliser-toutes-les-fonctions-personnalisees-dans-dautres-wworkbooks-1.png\" sizes=\"\" srcset=\"\" alt=\"di\u011fer wworkbook'lardaki t\u00fcm \u00f6zel i\u015flevleri kullanmak i\u00e7in dosyay\u0131 eklenti olarak kaydedin\"><\/figure><\/div><ul><li> Bundan sonra eklentiye \u00e7ift t\u0131klay\u0131n ve y\u00fckleyin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-ajouter-pour-ajouter-toutes-les-fonctions-definies-par-lutilisateur-dans-un-autre-classeur-1.png\" sizes=\"\" srcset=\"\" alt=\"Kullan\u0131c\u0131 tan\u0131ml\u0131 t\u00fcm i\u015flevleri ba\u015fka bir \u00e7al\u0131\u015fma kitab\u0131na eklemek i\u00e7in ekle'yi t\u0131klay\u0131n\"><\/figure><\/div><p> Bu kadar. Art\u0131k t\u00fcm VBA i\u015flevlerinizi herhangi bir \u00e7al\u0131\u015fma kitab\u0131nda kullanabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> \u00d6zel bir VBA i\u015flevi olu\u015fturman\u0131n farkl\u0131 yollar\u0131 [ileri d\u00fczey]<\/h2><p> Bu noktada VBA&#8217;da nas\u0131l \u00f6zel fonksiyon olu\u015fturulaca\u011f\u0131n\u0131 biliyorsunuz. Ancak sorun \u015fu ki, Yerle\u015fik i\u015flevleri kulland\u0131\u011f\u0131m\u0131zda, farkl\u0131 t\u00fcrde arg\u00fcmanlarla gelirler.<\/p><p> Bu k\u0131lavuzun bu b\u00f6l\u00fcm\u00fcnde farkl\u0131 arg\u00fcman t\u00fcrleriyle nas\u0131l UDF olu\u015fturulaca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.<\/p><ul><li> <strong>Herhangi bir tart\u0131\u015fma olmadan<\/strong><\/li><li> <strong>Tek bir arg\u00fcmanla<\/strong><\/li><li> <strong>Birka\u00e7 arg\u00fcmanla<\/strong><\/li><li> <strong>Arg\u00fcman olarak diziyi kullanma<\/strong><\/li><\/ul><p> \u2026ileriye do\u011fru ilerliyoruz.<\/p><h3 class=\"wp-block-heading\"> 1. Herhangi bir arg\u00fcman olmadan<\/h3><p> \u015e\u0130MD\u0130 ve BUG\u00dcN gibi arg\u00fcman girmenize gerek olmayan i\u015flevleri hat\u0131rl\u0131yor musunuz?<\/p><p> Evet. Herhangi bir ba\u011f\u0131ms\u0131z de\u011fi\u015fken girmenize gerek olmayan, kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flev olu\u015fturabilirsiniz. Bir \u00f6rnekle yapal\u0131m:<\/p><p> Ge\u00e7erli dosyan\u0131n konumunu d\u00f6nd\u00fcrebilecek \u00f6zel bir i\u015flev olu\u015ftural\u0131m. Ve i\u015fte kod:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Function myPath() As String Dim myLocation As String Dim myName As String myLocation = ActiveWorkbook.FullName myName = ActiveWorkbook.Name If myLocation = myName Then myPath = \"File is not saved yet.\" Else myPath = myLocation End If End Function<\/code><\/pre><p> Bu i\u015flev, ge\u00e7erli dosyan\u0131n depoland\u0131\u011f\u0131 konumun yolunu d\u00f6nd\u00fcr\u00fcr ve \u00e7al\u0131\u015fma kitab\u0131 herhangi bir yerde depolanmam\u0131\u015fsa &#8220;Dosya hen\u00fcz kaydedilmedi&#8221; \u015feklinde bir mesaj g\u00f6r\u00fcnt\u00fcler. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-une-fonction-definie-par-lutilisateur-sans-argument-1.png\" sizes=\"\" srcset=\"\" alt=\"ba\u011f\u0131ms\u0131z de\u011fi\u015fken olmadan kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flev olu\u015fturun\"><\/figure><\/div><p> \u015eimdi, e\u011fer bu fonksiyonun koduna \u00e7ok dikkat ederseniz, bir arg\u00fcman (parantez i\u00e7inde) tan\u0131mlaman\u0131za gerek kalmaz. Fonksiyon sonucu i\u00e7in veri tipini az \u00f6nce tan\u0131mlad\u0131n\u0131z.<\/p><p> Ba\u011f\u0131ms\u0131z de\u011fi\u015fken i\u00e7ermeyen bir i\u015flev olu\u015fturman\u0131n temel kural\u0131, hi\u00e7bir \u015fey yazman\u0131za gerek olmayan koddur.<\/p><p> Basit\u00e7e s\u00f6ylemek gerekirse, fonksiyondan geri almak istedi\u011finiz de\u011ferin otomatik olarak hesaplanmas\u0131 gerekir.<\/p><p> Ve bu fonksiyonda da ayn\u0131 \u015feye sahipsiniz.<\/p><p> Bu ActiveWorkbook.FullName dosyan\u0131n konumunu d\u00f6nd\u00fcr\u00fcr ve bu ActiveWorkbook.Name ad\u0131 d\u00f6nd\u00fcr\u00fcr. Hi\u00e7bir \u015fey girmenize gerek yok.<\/p><h3 class=\"wp-block-heading\"> 2. Tek arg\u00fcmanla<\/h3><p> Kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flevin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 \u00f6\u011frenerek bu konuyu zaten ele ald\u0131k. Ama biraz daha derine inelim ve farkl\u0131 bir i\u015flev yaratal\u0131m. Bu, birka\u00e7 ay \u00f6nce <a href=\"https:\/\/exceladvisor.org\/tr\/kopru-baglantisini-cikar\/\" data-wpel-link=\"internal\">bir k\u00f6pr\u00fcden URL&#8217;yi \u00e7\u0131karmak<\/a> i\u00e7in olu\u015fturdu\u011fum i\u015flevdir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Function giveMeURL(rng As Range) As String On Error Resume Next giveMeURL = rng.Hyperlinks(1).Address End Function<\/code><\/pre><p> \u015eimdi bu fonksiyonda yaln\u0131zca bir arg\u00fcman\u0131n\u0131z var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/fonction-personnalisee-simple-pour-extraire-lURL-dun-lien-hypertexte-1.png\" sizes=\"\" srcset=\"\" alt=\"URL'yi bir k\u00f6pr\u00fcden \u00e7\u0131karmak i\u00e7in basit \u00f6zel i\u015flev\"><\/figure><\/div><p> Bunu bir h\u00fccreye girdi\u011finizde ve ard\u0131ndan k\u00f6pr\u00fcn\u00fcn bulundu\u011fu h\u00fccreyi belirtti\u011finizde, k\u00f6pr\u00fcn\u00fcn URL&#8217;sini d\u00f6nd\u00fcrecektir. \u015eimdi bu fonksiyonda as\u0131l i\u015f \u015fu \u015fekilde yap\u0131l\u0131r:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">rng.Hyperlinks(1).Address<\/code><\/pre><p> Ancak rng belirtmeniz gereken \u015feydir. UDF olu\u015fturmay\u0131 kolay buluyorsan\u0131z yorumlar b\u00f6l\u00fcm\u00fcnde &#8220;Kolay&#8221; deyin.<\/p><h3 class=\"wp-block-heading\"> 3. \u00c7e\u015fitli arg\u00fcmanlarla<\/h3><p> Normalde <a style=\"outline: none; display: inline-block;\" href=\"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/\" data-wpel-link=\"internal\">\u00e7o\u011fu Excel yerle\u015fik i\u015flevinin birden<\/a> \u00e7ok ba\u011f\u0131ms\u0131z de\u011fi\u015fkeni vard\u0131r. Bu nedenle, birden fazla arg\u00fcmanla \u00f6zel bir i\u015flevin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 \u00f6\u011frenmeniz \u00e7ok \u00f6nemlidir.<\/p><p> Bir \u00f6rnek verelim: Bir metin dizesinden belirli harfleri \u00e7\u0131karmak ve geri kalan k\u0131sm\u0131n\u0131 korumak istiyorsunuz.<\/p><p> Bu \u00f6zel fonksiyonda kullanaca\u011f\u0131n\u0131z RIGHT ve LEN gibi fonksiyonlar\u0131n\u0131z var. Ama burada buna ihtiyac\u0131m\u0131z yok. Tek ihtiyac\u0131m\u0131z olan VBA kullanan \u00f6zel bir i\u015flev.<\/p><p> Yani, i\u015fte fonksiyon:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Function removeFirstC(rng As String, cnt As Long) As String removeFirstC = Right(rng, Len(rng) - cnt) End Functio<\/code><\/pre><p> Tamam o zaman bak: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/fonction-vba-avec-plusieurs-arguments-1.png\" sizes=\"\" srcset=\"\" alt=\"birden fazla arg\u00fcman i\u00e7eren vba i\u015flevi\"><\/figure><\/div><p> Bu fonksiyonda iki arg\u00fcman\u0131n\u0131z var:<\/p><ul><li> <strong><span style=\"color: #000000;\">rng:<\/span><\/strong> Bu ba\u011f\u0131ms\u0131z de\u011fi\u015fkende, bir metnin ilk karakterini kald\u0131rmak istedi\u011finiz h\u00fccreyi belirtmeniz gerekir.<\/li><li> <strong><span style=\"color: #000000;\">cnt:<\/span><\/strong> Ve arg\u00fcmanda kald\u0131r\u0131lacak karakter say\u0131s\u0131n\u0131 belirtmeniz gerekir (e\u011fer metinden birden fazla karakter kald\u0131rmak istiyorsan\u0131z).<\/li><\/ul><p> Bir h\u00fccreye girdi\u011finizde a\u015fa\u011f\u0131daki gibi \u00e7al\u0131\u015f\u0131r:<\/p><h4 class=\"wp-block-heading\"> 3.1 \u0130ste\u011fe ba\u011fl\u0131 ve gerekli ba\u011f\u0131ms\u0131z de\u011fi\u015fkenlerle kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flev olu\u015fturma<\/h4><p> Yukar\u0131daki \u00f6rnekte az \u00f6nce olu\u015fturdu\u011fumuz, iki farkl\u0131 arg\u00fcman\u0131n oldu\u011fu fonksiyonu d\u00fc\u015f\u00fcn\u00fcrseniz, her ikisi de gereklidir. Ve bunlardan herhangi birini ka\u00e7\u0131r\u0131rsan\u0131z, bunun gibi bir hata al\u0131rs\u0131n\u0131z.<\/p><p> \u015eimdi mant\u0131ksal d\u00fc\u015f\u00fcn\u00fcrseniz olu\u015fturdu\u011fumuz fonksiyon ilk karakteri kald\u0131rmakt\u0131r. Ancak burada kald\u0131r\u0131lacak karakter say\u0131s\u0131n\u0131 belirtmeniz gerekiyor. Demek istedi\u011fim, bu arg\u00fcman\u0131n iste\u011fe ba\u011fl\u0131 olmas\u0131 ve bir tanesini varsay\u0131lan olarak almas\u0131 gerekti\u011fidir.<\/p><p> Ne d\u00fc\u015f\u00fcn\u00fcyorsun?<\/p><p> Bu konuda benimle ayn\u0131 fikirdeyseniz yorum k\u0131sm\u0131na \u201cEvet\u201d deyin.<\/p><p> Tamam o zaman bak. Bir arg\u00fcman\u0131 iste\u011fe ba\u011fl\u0131 yapmak i\u00e7in \u00f6n\u00fcne &#8220;\u0130ste\u011fe Ba\u011fl\u0131&#8221; ifadesini eklemeniz yeterlidir. Aynen b\u00f6yle:<\/p><p> Ancak \u00f6nemli olan kodunuzun bu arg\u00fcman\u0131n de\u011feri olsun veya olmas\u0131n \u00e7al\u0131\u015fmas\u0131n\u0131 sa\u011flamakt\u0131r. Yani ayn\u0131 i\u015flev i\u00e7in yeni kodumuz \u015f\u00f6yle g\u00f6r\u00fcnecektir: \u015eimdi, e\u011fer ikinci arg\u00fcman\u0131 belirtmeyi g\u00f6z ard\u0131 ederseniz, kodda.<\/p><h3 class=\"wp-block-heading\"> 4. Diziyi arg\u00fcman olarak kullan\u0131n<\/h3><p> Dizi ba\u011f\u0131ms\u0131z de\u011fi\u015fkenlerini alabilen birka\u00e7 yerle\u015fik i\u015flev vard\u0131r ve bunu yapmak i\u00e7in \u00f6zel VBA i\u015flevinizi de olu\u015fturabilirsiniz.<\/p><p> Bunu, say\u0131lar\u0131n ve metnin bulundu\u011fu bir aral\u0131\u011f\u0131n de\u011ferlerini toplad\u0131\u011f\u0131n\u0131z bir fonksiyon olu\u015fturman\u0131z gereken basit bir \u00f6rnekle yapal\u0131m. Buraday\u0131z.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Function addNumbers(CellRef As Range) Dim Cell As Range For Each Cell In CellRef If IsNumeric(Cell.Value) = True Then Result = Result + Cell.Value End If Next Cell addNumbers = Result End Function<\/code><\/pre><p> Fonksiyonun yukar\u0131daki kodunda tek bir de\u011fer veya h\u00fccre referans\u0131 yerine A1:A10 tamsay\u0131 aral\u0131\u011f\u0131n\u0131 kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-fonction-vba-personnalisee-pour-additionner-le-nombre-dune-liste-1.png\" sizes=\"\" srcset=\"\" alt=\"bir listenin numaras\u0131n\u0131 eklemek i\u00e7in \u00f6zel bir vba i\u015flevi\"><\/figure><\/div><p> FOR EACH d\u00f6ng\u00fcs\u00fcn\u00fc kullanarak aral\u0131ktaki her h\u00fccreyi kontrol eder ve h\u00fccre bir say\u0131 i\u00e7eriyorsa de\u011feri toplar.<\/p><h2 class=\"wp-block-heading\"> Kullan\u0131c\u0131 tan\u0131ml\u0131 bir fonksiyonun kapsam\u0131<\/h2><p> Basit bir ifadeyle, bir fonksiyonun kapsam\u0131 onun di\u011fer prosed\u00fcrlerden \u00e7a\u011fr\u0131l\u0131p \u00e7a\u011fr\u0131lamayaca\u011f\u0131 anlam\u0131na gelir. Bir FDU&#8217;nun iki farkl\u0131 kapsam\u0131 olabilir.<\/p><h3 class=\"wp-block-heading\"> 1. \u0130zleyici<\/h3><p> \u00d6zel i\u015flevinizi herkese a\u00e7\u0131k hale getirerek \u00e7al\u0131\u015fma kitab\u0131ndaki t\u00fcm \u00e7al\u0131\u015fma sayfalar\u0131nda \u00e7a\u011f\u0131rabilirsiniz. Bir i\u015flevi herkese a\u00e7\u0131k hale getirmek i\u00e7in a\u015fa\u011f\u0131daki gibi &#8220;Genel&#8221; kelimesini kullanman\u0131z yeterlidir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-pubilc-avant-le-nom-de-la-fonction-personnalisee-vba-1.png\" sizes=\"\" srcset=\"\" alt=\"vba \u00f6zel i\u015flev ad\u0131ndan \u00f6nce pubilc ekleyin\"><\/figure><\/div><p> Ancak bir i\u015flevi \u00f6zel yapmazsan\u0131z varsay\u0131lan olarak genel bir i\u015flevdir. Ele ald\u0131\u011f\u0131m\u0131z t\u00fcm \u00f6rneklerde hepsi halka a\u00e7\u0131kt\u0131r.<\/p><h3 class=\"wp-block-heading\"> 2. \u00d6zel<\/h3><p> Bir fonksiyonu \u00f6zel yapt\u0131\u011f\u0131n\u0131zda onu ayn\u0131 mod\u00fcldeki prosed\u00fcrlerde kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-prive-avant-le-nom-de-la-fonction-personnalisee-vba-1.png\" sizes=\"\" srcset=\"\" alt=\"\u00f6zel i\u015flev ad\u0131 vba'dan \u00f6nce \u00f6zel ekle\"><\/figure><\/div><p> Diyelim ki &#8220;Module1&#8243;de UDF&#8217;niz varsa onu sadece &#8220;Module1&#8243;de yapt\u0131\u011f\u0131n\u0131z i\u015flemlerde kullanabilirsiniz. Ve \u00e7al\u0131\u015fma sayfas\u0131 i\u015flevler listesinde g\u00f6r\u00fcnmez (= i\u015faretini kulland\u0131\u011f\u0131n\u0131zda ve ad\u0131 yazmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda), ancak yine de ad\u0131n\u0131 yaz\u0131p ba\u011f\u0131ms\u0131z de\u011fi\u015fkenleri belirterek kullanabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Kullan\u0131c\u0131 Tan\u0131ml\u0131 \u0130\u015flevin S\u0131n\u0131rlamalar\u0131 [UDF]<\/h2><p> UDF&#8217;ler son derece kullan\u0131\u015fl\u0131d\u0131r. Ancak baz\u0131 durumlarda s\u0131n\u0131rl\u0131d\u0131rlar. VBA&#8217;da \u00f6zel bir i\u015flev olu\u015ftururken not etmenizi ve hat\u0131rlaman\u0131z\u0131 istedi\u011fim birka\u00e7 \u015fey var.<\/p><ul><li> \u00d6zel bir i\u015flev kullanarak h\u00fccreleri ve aral\u0131\u011f\u0131 d\u00fczenleyemez, silemez veya bi\u00e7imlendiremezsiniz.<\/li><li> Ayr\u0131ca \u00e7al\u0131\u015fma kitab\u0131n\u0131 ta\u015f\u0131yamaz, yeniden adland\u0131ramaz, silemez veya \u00e7al\u0131\u015fma kitab\u0131na ekleyemezsiniz.<\/li><li> Ba\u015fka bir h\u00fccrenin de\u011ferini de\u011fi\u015ftirin.<\/li><li> Ayr\u0131ca ortam se\u00e7eneklerini de\u011fi\u015ftiremez.<\/li><\/ul><h2 class=\"wp-block-heading\"> Yerle\u015fik bir i\u015flev ile kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flev aras\u0131nda bir fark var m\u0131?<\/h2><p> Sordu\u011funa sevindim. Bu soruyu cevaplamak i\u00e7in sizin i\u00e7in \u00f6nemli oldu\u011funu d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fcm baz\u0131 noktalar\u0131 payla\u015fmak istiyorum.<\/p><ol><li> <strong><span style=\"color: #000000;\">Yerle\u015fikten daha yava\u015f:<\/span><\/strong> Yerle\u015fik i\u015flevlerle VBA i\u015flevlerinin h\u0131z\u0131n\u0131 kar\u015f\u0131la\u015ft\u0131r\u0131rsan\u0131z, ilkinin h\u0131zl\u0131 oldu\u011funu g\u00f6receksiniz. Bunun nedeni yerle\u015fik fonksiyonlar\u0131n C++ veya FORTRAN dilinde yaz\u0131lm\u0131\u015f olmas\u0131d\u0131r.<\/li><li> <span style=\"color: #000000;\"><strong>Dosya payla\u015fman\u0131n zorlu\u011fu:<\/strong><\/span> Dosyalar\u0131 genellikle e-posta ve bulut arac\u0131l\u0131\u011f\u0131yla payla\u015f\u0131r\u0131z. \u00d6zel i\u015flevlerden herhangi birini kullan\u0131yorsan\u0131z, ba\u015fka birinin de \u00f6zel i\u015flevinizi kullanabilmesi i\u00e7in bu dosyay\u0131 &#8220;xlam&#8221; format\u0131nda payla\u015fman\u0131z gerekir.<\/li><\/ol><p> Ancak yukar\u0131da &#8220;Neden \u00d6zel Excel \u0130\u015flevi Olu\u015fturmal\u0131s\u0131n\u0131z&#8221; b\u00f6l\u00fcm\u00fcnde s\u00f6yledi\u011fim gibi, VBA\u00f6zel i\u015flevini tercih edebilece\u011finiz belirli durumlar vard\u0131r.<\/p><h2 class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> Kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flev olu\u015fturmak basittir. Tek yapman\u0131z gereken, onu bir fonksiyon olarak tan\u0131mlamak, arg\u00fcmanlar eklemek, arg\u00fcmanlar\u0131n veri tipini ayarlamak ve ard\u0131ndan d\u00f6n\u00fc\u015f de\u011feri i\u00e7in veri tipini ayarlamak i\u00e7in ad\u0131ndan \u00f6nce &#8220;Fonksiyon&#8221; kullanmakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-illustration-simple-pour-comprendre-comment-creer-une-fonction-definie-par-lutilisateur-1.png\" sizes=\"\" srcset=\"\" alt=\"kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flevin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 anlamak i\u00e7in basit bir \u00f6rnek\"><\/figure><\/div><p> Son olarak fonksiyondan geri almak istedi\u011finiz de\u011feri hesaplamak i\u00e7in kodu ekleyin. Bug\u00fcn sizlerle payla\u015ft\u0131\u011f\u0131m bu rehber, VBA&#8217;da \u00f6zel fonksiyon olu\u015fturmay\u0131 \u00f6\u011frenmenin en kolay rehberidir ve eminim faydal\u0131 bulmu\u015fsunuzdur.<\/p><p> Ama \u015fimdi bana bir \u015feyi s\u00f6yle.<\/p><p> <strong>UDF&#8217;ler faydal\u0131d\u0131r, ne d\u00fc\u015f\u00fcn\u00fcyorsunuz?<\/strong><\/p><p> L\u00fctfen g\u00f6r\u00fc\u015flerinizi yorum k\u0131sm\u0131nda benimle payla\u015f\u0131n. Sizden haber almay\u0131 \u00e7ok isterim ve l\u00fctfen bu g\u00f6nderiyi arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n, eminim onlar da bunu takdir edeceklerdir.<\/p><h2 class=\"wp-block-heading\"> <strong>\u0130lgili e\u011fitimler<\/strong><\/h2><ul><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/islevler\/\" data-wpel-link=\"internal\">VBA i\u015flevlerinin listesi \u2013 \u00f6rneklerle a\u00e7\u0131klanm\u0131\u015ft\u0131r<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/\" data-wpel-link=\"internal\">Excel&#8217;de makro nas\u0131l \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/eger-2\/\" data-wpel-link=\"internal\">VBA&#8217;da IF deyimi nas\u0131l kullan\u0131l\u0131r?<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/aralik-1\/\" data-wpel-link=\"internal\">VBA&#8217;da aral\u0131klar ve h\u00fccrelerle nas\u0131l \u00e7al\u0131\u015f\u0131l\u0131r<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/\" data-wpel-link=\"internal\">VBA kodunu kullanarak yeni bir sayfa ekleyin<\/a><\/li><\/ul>","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-1863","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&#039;da kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flev nas\u0131l olu\u015fturulur?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde VBA kullanarak Excel&#039;de KULLANICI TANIMLI \u0130\u015eLEV (UDF) olu\u015fturmay\u0131 ve ayr\u0131ca\" \/>\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\/kullanici-tanimli-fonksiyon-2\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA&#039;da kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flev nas\u0131l olu\u015fturulur?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde VBA kullanarak Excel&#039;de KULLANICI TANIMLI \u0130\u015eLEV (UDF) olu\u015fturmay\u0131 ve ayr\u0131ca\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:07:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-le-mot-udf-pour-savoir-pourquoi-la-creation-dune-fonction-personnalisee-est-importante-1.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=\"18 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/\",\"name\":\"VBA&#39;da kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flev nas\u0131l olu\u015fturulur?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-le-mot-udf-pour-savoir-pourquoi-la-creation-dune-fonction-personnalisee-est-importante-1.png\",\"datePublished\":\"2023-10-30T18:34:26+00:00\",\"dateModified\":\"2023-12-10T06:07:48+00:00\",\"description\":\"Bu e\u011fitimde VBA kullanarak Excel&#39;de KULLANICI TANIMLI \u0130\u015eLEV (UDF) olu\u015fturmay\u0131 ve ayr\u0131ca\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-le-mot-udf-pour-savoir-pourquoi-la-creation-dune-fonction-personnalisee-est-importante-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-le-mot-udf-pour-savoir-pourquoi-la-creation-dune-fonction-personnalisee-est-importante-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba&#39;da kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flev nas\u0131l olu\u015fturulur?\"}]},{\"@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&#39;da kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flev nas\u0131l olu\u015fturulur?","description":"Bu e\u011fitimde VBA kullanarak Excel&#39;de KULLANICI TANIMLI \u0130\u015eLEV (UDF) olu\u015fturmay\u0131 ve ayr\u0131ca","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\/kullanici-tanimli-fonksiyon-2\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA&#39;da kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flev nas\u0131l olu\u015fturulur?","og_description":"Bu e\u011fitimde VBA kullanarak Excel&#39;de KULLANICI TANIMLI \u0130\u015eLEV (UDF) olu\u015fturmay\u0131 ve ayr\u0131ca","og_url":"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:07:48+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-le-mot-udf-pour-savoir-pourquoi-la-creation-dune-fonction-personnalisee-est-importante-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"18 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/","url":"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/","name":"VBA&#39;da kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flev nas\u0131l olu\u015fturulur?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-le-mot-udf-pour-savoir-pourquoi-la-creation-dune-fonction-personnalisee-est-importante-1.png","datePublished":"2023-10-30T18:34:26+00:00","dateModified":"2023-12-10T06:07:48+00:00","description":"Bu e\u011fitimde VBA kullanarak Excel&#39;de KULLANICI TANIMLI \u0130\u015eLEV (UDF) olu\u015fturmay\u0131 ve ayr\u0131ca","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-le-mot-udf-pour-savoir-pourquoi-la-creation-dune-fonction-personnalisee-est-importante-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-le-mot-udf-pour-savoir-pourquoi-la-creation-dune-fonction-personnalisee-est-importante-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba&#39;da kullan\u0131c\u0131 tan\u0131ml\u0131 bir i\u015flev nas\u0131l olu\u015fturulur?"}]},{"@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\/1863","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=1863"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1863\/revisions"}],"predecessor-version":[{"id":2952,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1863\/revisions\/2952"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}