{"id":1842,"date":"2023-10-31T18:23:37","date_gmt":"2023-10-31T18:23:37","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/"},"modified":"2023-12-10T06:01:37","modified_gmt":"2023-12-10T06:01:37","slug":"vba-mesaj-kutusu","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/","title":{"rendered":"Excel&#39;de mesaj kutusu i\u015flevleri nas\u0131l olu\u015fturulur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1218316574\"><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 hakk\u0131nda \u00f6\u011frendi\u011fim ilk \u015fey mesaj kutusunun (&#8220;msgbox i\u015flevi&#8221;) nas\u0131l kullan\u0131laca\u011f\u0131yd\u0131. Belirli bir mesaj\u0131 g\u00f6r\u00fcnt\u00fclemek i\u00e7in Excel pencerenizdeki basit bir a\u00e7\u0131l\u0131r kutuya benzer. D\u00fc\u015f\u00fcn\u00fcrseniz iki \u015fekilde kullanabilirsiniz.<\/p><ul><li> <strong>Kullan\u0131c\u0131ya bir mesaj iletin.<\/strong><\/li><li> <strong>Kullan\u0131c\u0131dan basit bir yan\u0131t al\u0131n.<\/strong><\/li><\/ul><p> \u00c7o\u011fu VBA programc\u0131s\u0131, makro kodlar\u0131nda onlar\u0131 daha etkile\u015fimli hale getirmek i\u00e7in kullan\u0131r ve e\u011fer bilmiyorsan\u0131z, bahse girerim bu makaleyi okuduktan sonra ona a\u015f\u0131k olacaks\u0131n\u0131z.<\/p><p> <strong><span style=\"background-color: #ffff00;\">Uzman \u0130pucu:<\/span><\/strong> VBA&#8217;ya yeni ba\u015fl\u0131yorsan\u0131z, VBA mesaj kutusu hakk\u0131nda daha fazla bilgi edinmek iyi bir fikir olabilir.<\/p><p> Bu nedenle, bug\u00fcn bu makalede Excel&#8217;de mesaj kutusu kullan\u0131m\u0131na ili\u015fkin t\u00fcm ayr\u0131nt\u0131lar\u0131 ve ger\u00e7ek d\u00fcnyadan baz\u0131 \u00f6rnekleri sizlerle payla\u015fmak istiyorum.<\/p><p> \u2026Ba\u015flayal\u0131m.<\/p><h2> S\u00f6zdizimi<\/h2><p> =MSGBOX(istem, [d\u00fc\u011fmeler], [ba\u015fl\u0131k], [yard\u0131m dosyas\u0131, ba\u011flam]) <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png\" sizes=\"auto, \" srcset=\"\" alt=\"msgbox vba i\u015flevi s\u00f6zdizimi\" width=\"317\" height=\"250\" data-attachment-id=\"14803\"><\/p><ul><li> istem Bir mesaj olarak g\u00f6r\u00fcnt\u00fclemek i\u00e7in kullan\u0131lan dize ifadesi. Maksimum karakter uzunlu\u011fu, karakter geni\u015fli\u011fine ba\u011fl\u0131 olarak 1024&#8217;t\u00fcr.<\/li><li> [d\u00fc\u011fmeler] Bu ba\u011f\u0131ms\u0131z de\u011fi\u015fkeni d\u00fc\u011fmeleri, simge stilini, d\u00fc\u011fme kimli\u011fini ve mesaj kutusu modunu belirtmek i\u00e7in kullanabilirsiniz.<\/li><li> [title] Bu arg\u00fcman\u0131 mesaj kutunuzun ba\u015fl\u0131k metnini belirtmek i\u00e7in kullanabilirsiniz.<\/li><li> [yard\u0131m dosyas\u0131] Bu arg\u00fcman, kullan\u0131c\u0131 i\u00e7in bir yard\u0131m dosyas\u0131 belirlemenize yard\u0131mc\u0131 olacakt\u0131r. Kullan\u0131c\u0131 bu yard\u0131m dosyas\u0131na yard\u0131m butonunu kullanarak eri\u015febilir. Bir yard\u0131m dosyas\u0131 belirtirseniz ba\u011flam numaras\u0131 belirtmeniz zorunludur.<\/li><li> [ba\u011flam] Yard\u0131m men\u00fcs\u00fcnden bir yard\u0131m konusu atamak i\u00e7in kullan\u0131lan say\u0131sal ifade.<\/li><\/ul><p> <strong>Not:<\/strong> Yukar\u0131daki listede k\u00f6\u015feli parantez i\u00e7indeki ba\u011f\u0131ms\u0131z de\u011fi\u015fkenler iste\u011fe ba\u011fl\u0131d\u0131r; bunlar\u0131 belirtmeyi atlayabilirsiniz.<\/p><h2> Bir mesaj kutusu nas\u0131l \u00f6zelle\u015ftirilir ve farkl\u0131 d\u00fc\u011fmeler nas\u0131l kullan\u0131l\u0131r?<\/h2><p> Bir VBA mesaj kutusunu mevcut t\u00fcm se\u00e7eneklerle kolayca \u00f6zelle\u015ftirebilirsiniz. Bu se\u00e7eneklere bir g\u00f6z atal\u0131m. <\/p><h3 style=\"font-size: 22px; margin-bottom: 20px !important; margin-top: 0px !important;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #1. vbOKYaln\u0131zca<\/h3><p> Bu size basit bir Tamam d\u00fc\u011fmesi verir. Kullan\u0131c\u0131 mesaj\u0131 okuduktan sonra kapatmak i\u00e7in \u00fczerine t\u0131klayabilir. Ayr\u0131ca Tamam d\u00fc\u011fmesine t\u0131kland\u0131\u011f\u0131nda \u00e7al\u0131\u015ft\u0131rmak i\u00e7in bir makro da kullanabilirsiniz. <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbokonly.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"142\" height=\"143\" data-attachment-id=\"14806\"><\/p><p> OKOnly() alt\u0131nda<\/p><p> MsgBox Komut \u0130stemi := \u201cBu bir MsgBox&#8217;t\u0131r\u201d, _<\/p><p> D\u00fc\u011fmeler:=vbOKOnly, _<\/p><p> Ba\u015fl\u0131k: = &#8220;Posta Kutusu&#8221;<\/p><p> Altyaz\u0131 biti\u015fi <\/p><h3 style=\"font-size: 22px; margin-bottom: 20px !important; margin-top: 0px !important;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #2. vbOK\u0130ptal<\/h3><p> Bu sabit size bir Tamam ve iptal d\u00fc\u011fmesi verir. Kullan\u0131c\u0131n\u0131n art\u0131k devam etmek i\u00e7in Tamam&#8217;a basmak veya \u00e7\u0131kmak i\u00e7in iptal etmek i\u00e7in iki se\u00e7ene\u011fi vard\u0131r. <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbokcancel.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"237\" height=\"143\" data-attachment-id=\"14808\"><\/p><p> OKCancel() alt\u0131nda<\/p><p> MsgBox istemi:= \u00bb\u0130yi misin? \u00bb, _<\/p><p> D\u00fc\u011fmeler:=vbOKCancel, _<\/p><p> Ba\u015fl\u0131k: = &#8220;Posta Kutusu&#8221;<\/p><p> Altyaz\u0131 biti\u015fi <\/p><h3 style=\"margin-bottom: 15px !important; margin-top: 0px !important; font-size: 22px;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #3. vbAbortYeniden DeneYoksay<\/h3><p> Bu, Hakk\u0131nda, Yeniden Dene ve Atla i\u00e7in \u00fc\u00e7 d\u00fc\u011fme g\u00f6r\u00fcnt\u00fclemenize olanak tan\u0131r. Kullan\u0131c\u0131 i\u015flemi iptal edebilir, yeniden deneyebilir veya g\u00f6z ard\u0131 edebilir. <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbabortretryignore.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"335\" height=\"143\" data-attachment-id=\"14810\"><\/p><p> OKCancel() alt\u0131nda<\/p><p> MsgBox istemi:= \u00bb\u0130yi misin? \u00bb, _<\/p><p> D\u00fc\u011fmeler:=vbOKCancel, _<\/p><p> Ba\u015fl\u0131k: = &#8220;Posta Kutusu&#8221;<\/p><p> Altyaz\u0131 biti\u015fi <\/p><h3 style=\"font-size: 22px; margin-bottom: 20px !important; margin-top: 0px !important;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #4. vbEvetHay\u0131r\u0130ptal<\/h3><p> Bu sabit Evet, Hay\u0131r ve \u0130ptal i\u00e7in \u00fc\u00e7 d\u00fc\u011fme g\u00f6r\u00fcnt\u00fcler. Kullan\u0131c\u0131 kabul edip devam etmek i\u00e7in Evet&#8217;i, reddetmek i\u00e7in Hay\u0131r&#8217;\u0131 veya mesaj kutusunu kapatmak i\u00e7in iptal edebilir. <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbyesnocancel.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"335\" height=\"143\" data-attachment-id=\"14812\"><\/p><p> YesNoCancel() alt\u0131nda<\/p><p> MsgBox Prompt := &#8220;Art\u0131k \u00fc\u00e7 d\u00fc\u011fmeniz var&#8221;, _<\/p><p> D\u00fc\u011fmeler:=vbYesNoCancel, _<\/p><p> Ba\u015fl\u0131k: = &#8220;Posta Kutusu&#8221;<\/p><p> Altyaz\u0131 biti\u015fi <\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #5. vbEvetHay\u0131r<\/h3><p> Bu sabit, Evet ve Hay\u0131r i\u00e7in iki d\u00fc\u011fme g\u00f6r\u00fcnt\u00fcler. Kullan\u0131c\u0131 kabul etmek ve devam etmek i\u00e7in Evet&#8217;e veya reddetmek i\u00e7in Hay\u0131r&#8217;a t\u0131klayabilir. <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbyesno.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"237\" height=\"143\" data-attachment-id=\"14816\"><\/p><p> EvetHay\u0131r() alt\u0131nda<\/p><p> MsgBox Prompt := &#8220;Art\u0131k iki butonunuz var&#8221;, _<\/p><p> D\u00fc\u011fmeler:=vbEvetHay\u0131r, _<\/p><p> Ba\u015fl\u0131k: = &#8220;Posta Kutusu&#8221;<\/p><p> Altyaz\u0131 biti\u015fi <\/p><h3 style=\"margin-bottom: 15px !important; font-size: 22px;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #6. vbYeniden Dene\u0130ptal<\/h3><p> \u015eimdi iki d\u00fc\u011fme g\u00f6steriliyor; yeniden dene ve iptal et. Kullan\u0131c\u0131dan i\u015flemi yeniden denemesini veya iptal etmesini istemek i\u00e7in bunu kullanabilirsiniz. <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbretrycancel.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"237\" height=\"143\" data-attachment-id=\"14819\"><\/p><p> Sub RetryCancel()MsgBox Prompt:=\u201dL\u00fctfen tekrar deneyin\u201d, _Buttons:=vbRetryCancel, _Title:=\u201dMsgBox\u201dEnd Sub <\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #7. vb\u0130nceleme<\/h3><p> Bu sabit, mesaj kutusunda mesaj\u0131n kritik oldu\u011funu belirten bir simge g\u00f6r\u00fcnt\u00fcler. <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbcritical.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"175\" height=\"160\" data-attachment-id=\"14822\"><\/p><p> Subkritik()<\/p><p> MsgBox Komut \u0130stemi := \u201cBu kritik\u201d, _<\/p><p> D\u00fc\u011fmeler:=vbCritical, _<\/p><p> Ba\u015fl\u0131k: = &#8220;Posta Kutusu&#8221;<\/p><p> Altyaz\u0131 biti\u015fi <\/p><h3 style=\"margin-bottom: 15px !important; font-size: 22px;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #8. vbSoru<\/h3><p> Bu sabit kullan\u0131c\u0131ya bir soru soruldu\u011funda kullan\u0131labilir. <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbquestion.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"195\" height=\"160\" data-attachment-id=\"14825\"><\/p><p> Alt Soru()<\/p><p> MsgBox Komut \u0130stemi := \u00bb\u015eimdi ne yapmal\u0131? \u00bb, _<\/p><p> D\u00fc\u011fmeler:=vbSoru, _<\/p><p> Ba\u015fl\u0131k: = &#8220;Posta Kutusu&#8221;<\/p><p> Altyaz\u0131 biti\u015fi <\/p><h3 style=\"margin-bottom: 15px !important; margin-top: 0px !important; font-size: 22px;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #9. vb\u00dcnlem<\/h3><p> Bu sabit, mesajla birlikte bir \u00fcnlem simgesi g\u00f6r\u00fcnt\u00fcleyecektir. <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbexclamation.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"195\" height=\"160\" data-attachment-id=\"14828\"><\/p><p> \u00dcnlem Alt\u0131nda()<\/p><p> MsgBox Komut \u0130stemi := \u00bb\u015eimdi ne yapmal\u0131? \u00bb, _<\/p><p> D\u00fc\u011fmeler:=vb\u00dcnlem, _<\/p><p> Ba\u015fl\u0131k: = &#8220;Posta Kutusu&#8221;<\/p><p> Altyaz\u0131 biti\u015fi <\/p><h3 style=\"margin-bottom: 15px !important; margin-top: 0px !important; font-size: 22px;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #on. vbBilgi<\/h3><p> Mesaj\u0131n bilgi oldu\u011funu belirten bir simge g\u00f6r\u00fcnt\u00fclenecektir. <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbinformation.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"195\" height=\"160\" data-attachment-id=\"14829\"><\/p><p> Sub Information()MsgBox Prompt:=\u201d\u015eimdi ne yapmal\u0131?\u201d, _Buttons:=vbInformation, _Title:=\u201dMsgBox\u201dEnd Sub <\/p><h3 style=\"margin-bottom: 15px !important; font-size: 22px;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #11. vbDefaultButton1<\/h3><p> Mesaj kutunuzdaki ilk d\u00fc\u011fmeyi varsay\u0131lan d\u00fc\u011fme olarak belirtmek i\u00e7in bu sabiti kullan\u0131n. <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbdefaultbutton1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"431\" height=\"143\" data-attachment-id=\"14833\"><\/p><p> Sub DefaultButton1()MsgBox Prompt:=\u201dButton1 Vurguland\u0131 m\u0131?\u201d, _Buttons:=vbYesNoCancel + vbMsgBoxHelpButton + vbDefaultButton1, _Title:=\u201dMsgBox\u201dEnd Sub <\/p><h3 style=\"margin-bottom: 15px !important; font-size: 22px;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #12. vbDefaultButton2<\/h3><p> Mesaj kutunuzdaki ikinci d\u00fc\u011fmeyi varsay\u0131lan d\u00fc\u011fme olarak belirtmek i\u00e7in bu sabiti kullan\u0131n. <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/msgbox-vba-avec-vbdefaultbutton2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"431\" height=\"143\" data-attachment-id=\"14834\"><\/p><p> Sub DefaultButton2()MsgBox Prompt:=\u201dButton2 Vurguland\u0131 m\u0131?\u201d, _Buttons:=vbYesNoCancel + vbMsgBoxHelpButton + vbDefaultButton2, _Title:=\u201dMsgBox\u201dEnd Sub <\/p><h3 style=\"margin-bottom: 15px !important; font-size: 22px;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #13. vbDefaultButton3<\/h3><p> Mesaj kutunuzdaki \u00fc\u00e7\u00fcnc\u00fc d\u00fc\u011fmeyi varsay\u0131lan d\u00fc\u011fme olarak belirtmek i\u00e7in bu sabiti kullan\u0131n. <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/msgbox-vba-avec-vbdefaultbutton3.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"431\" height=\"143\" data-attachment-id=\"14835\"><\/p><p> Sub DefaultButton3()MsgBox Prompt:=\u201dButton3 Vurguland\u0131 m\u0131?\u201d, _Buttons:=vbYesNoCancel + vbMsgBoxHelpButton + vbDefaultButton3, _Title:=\u201dMsgBox\u201dEnd Sub <\/p><h3 style=\"margin-bottom: 15px !important; font-size: 22px;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #14. vbDefaultButton4<\/h3><p> Mesaj kutunuzdaki d\u00f6rd\u00fcnc\u00fc d\u00fc\u011fmeyi varsay\u0131lan d\u00fc\u011fme olarak belirtmek i\u00e7in bu sabiti kullan\u0131n. <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-msgbox-avec-vbdefaultbutton4.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"431\" height=\"143\" data-attachment-id=\"14836\"><\/p><p> Sub DefaultButton4()MsgBox Prompt:=\u201dButton4 Vurguland\u0131 m\u0131?\u201d, _Buttons:=vbYesNoCancel + vbMsgBoxHelpButton + vbDefaultButton4, _Title:=\u201dMsgBox\u201dEnd Sub <\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important; margin-top: 0px !important;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #15. vbApplicationModal<\/h3><p> Bu sabit uygulamay\u0131 (Excel) ask\u0131ya alacakt\u0131r, kullan\u0131c\u0131n\u0131n uygulamay\u0131 kullanabilmesi i\u00e7in msgbox&#8217;a yan\u0131t vermesi gerekir.<\/p><p> OKOnly() alt\u0131nda<\/p><p> MsgBox Komut \u0130stemi := \u201cBu bir MsgBox&#8217;t\u0131r\u201d, _<\/p><p> D\u00fc\u011fmeler:=vbOKOnly, _<\/p><p> Ba\u015fl\u0131k: = &#8220;Posta Kutusu&#8221;, _<\/p><p> Altyaz\u0131 biti\u015fi <\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important; margin-top: 0px !important;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #16. vbSystemModal<\/h3><p> Bu sabit i\u015fletim sisteminizdeki t\u00fcm uygulamalar\u0131 ask\u0131ya alacakt\u0131r, kullan\u0131c\u0131n\u0131n \u00f6ncelikle mesaj kutusuna yan\u0131t vermesi gerekir.<\/p><p> Sub ApplicationModal()MsgBox Prompt := \u00bbBu uygulama modelidir\u00bb, _Buttons :=vbOK + vbApplicationModal, _Title := \u00bbMsgBox \u00bbEnd Sub <\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important; margin-top: 0px !important;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #17. vbMsgBoxYard\u0131mD\u00fc\u011fmesi<\/h3><p> Posta kutunuza bir yard\u0131m d\u00fc\u011fmesi eklemek i\u00e7in bu sabiti kullan\u0131n. Yard\u0131m d\u00fc\u011fmesini kullanmak i\u00e7in bir yard\u0131m dosyas\u0131 ve ba\u011flam numaras\u0131 ekleyebilirsiniz.<\/p><p> Sub HelpButton()MsgBox Prompt:=\u201dYard\u0131m D\u00fc\u011fmesini Kullan\u201d, _Buttons:=vbOK + vbMsgBoxHelpButton, _Title:=\u201dMsgBox\u201d, _HelpFile:=\u201dC:UsersPuneet GogiaDesktopsamplehelp.chm\u201d, _Context:=101End Sub<\/p><p> Kullan\u0131c\u0131 yard\u0131m d\u00fc\u011fmesine t\u0131klad\u0131\u011f\u0131nda bir yard\u0131m men\u00fcs\u00fc a\u00e7\u0131l\u0131r. <\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important; margin-top: 0px !important;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #18. vbMsgBoxSet\u00d6n Plan<\/h3><p> Bu sabit, mesaj kutusu pencerenizi \u00f6n plan penceresi yapman\u0131za yard\u0131mc\u0131 olacakt\u0131r.<\/p><p> Sub SetForeground()MsgBox Prompt:=\u201dBu MsgBox \u00f6n plandad\u0131r\u201d, _Buttons:=vbOK + vbMsgBoxSetForeground, _Title:=\u201dMsgBox\u201dEnd Sub <\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important; margin-top: 0px !important;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #19. vbMsgBoxRight<\/h3><p> Metin bu sabit kullan\u0131larak sa\u011fa hizalanacakt\u0131r.<\/p><p> MsgBoxRight() alt\u0131nda<\/p><p> MsgBox Prompt := \u201cMetin sa\u011fda\u201d, _<\/p><p> D\u00fc\u011fmeler:=vbOK + vbMsgBoxRight, _<\/p><p> Ba\u015fl\u0131k: = &#8220;Posta Kutusu&#8221;<\/p><p> Altyaz\u0131 biti\u015fi <\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important; margin-top: 0px !important;\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-fontsize=\"18\" data-lineheight=\"27\"> #20. vbMsgBoxRtlReading<\/h3><p> Bu sabiti kullanarak mesaj kutusu sa\u011fa d\u00f6necektir. Bu sabit \u00f6ncelikle \u0130branice ve Arap\u00e7a sistemler i\u00e7in tasarlanm\u0131\u015ft\u0131r.<\/p><p> MsgBoxRtlRead() alt\u0131nda<\/p><p> MsgBox Prompt := \u201cBu kutu ters \u00e7evrildi\u201d, _<\/p><p> D\u00fc\u011fmeler:=vbOK + vbMsgBoxRtlRead, _<\/p><p> Ba\u015fl\u0131k: = &#8220;Posta Kutusu&#8221;<\/p><p> Altyaz\u0131 biti\u015fi <\/p><h2 id=\"tab-con-8\" style=\"margin-bottom: 20px !important;\" data-fontsize=\"28\" data-lineheight=\"42\"> D\u00f6n\u00fc\u015f de\u011ferleri<\/h2><p> Bir kullan\u0131c\u0131 d\u00fc\u011fmelerden birine t\u0131klayarak mesaj kutusuna her yan\u0131t verdi\u011finde bir say\u0131 olu\u015fturulur. Bu, kullan\u0131c\u0131n\u0131n hangi d\u00fc\u011fmeyi t\u0131klad\u0131\u011f\u0131n\u0131 belirlemenize yard\u0131mc\u0131 olacakt\u0131r. <\/p><table class=\"mtr-table mtr-thead-th\" style=\"margin-top: 0px !important; margin-bottom: 20px !important;\" data-rows=\"8\" data-cols=\"3\" data-tve-custom-colour=\"16460717\"><thead><tr><th class=\"mtr-th-tag\" data-tve-custom-colour=\"55690541\" data-mtr-content=\"Constant\"><div class=\"mtr-cell-content\"> Devaml\u0131 <\/div><\/th><th class=\"mtr-th-tag\" data-tve-custom-colour=\"29870761\" data-mtr-content=\"Value\"><div class=\"mtr-cell-content\"> De\u011fer <\/div><\/th><th class=\"mtr-th-tag\" data-tve-custom-colour=\"55301951\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Tan\u0131m <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-tve-custom-colour=\"41996507\" data-mtr-content=\"Constant\"><div class=\"mtr-cell-content\"> vbOK <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"28891566\" data-mtr-content=\"Value\"><div class=\"mtr-cell-content\"> 1 <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"50801664\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> ELBETTE <\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-tve-custom-colour=\"98145453\" data-mtr-content=\"Constant\"><div class=\"mtr-cell-content\"> vb\u0130ptal <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"35044744\" data-mtr-content=\"Value\"><div class=\"mtr-cell-content\"> 2 <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"33697450\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> \u0130ptal etmek <\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-tve-custom-colour=\"29220062\" data-mtr-content=\"Constant\"><div class=\"mtr-cell-content\"> vb\u0130ptal <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"44631822\" data-mtr-content=\"Value\"><div class=\"mtr-cell-content\"> 3 <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"87798468\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> K\u00fcrtaj <\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-tve-custom-colour=\"67330579\" data-mtr-content=\"Constant\"><div class=\"mtr-cell-content\"> vbTekrar dene <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"714382\" data-mtr-content=\"Value\"><div class=\"mtr-cell-content\"> 4 <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"97829037\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Tekrar ba\u015fla <\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-tve-custom-colour=\"24936662\" data-mtr-content=\"Constant\"><div class=\"mtr-cell-content\"> vbAtla <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"51432601\" data-mtr-content=\"Value\"><div class=\"mtr-cell-content\"> 5 <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"26493383\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> G\u00f6rmezden gelmek <\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-tve-custom-colour=\"52901802\" data-mtr-content=\"Constant\"><div class=\"mtr-cell-content\"> vb Evet <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"48521301\" data-mtr-content=\"Value\"><div class=\"mtr-cell-content\"> 6 <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"67193381\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> Evet <\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-tve-custom-colour=\"24036290\" data-mtr-content=\"Constant\"><div class=\"mtr-cell-content\"> vbHay\u0131r <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"22797535\" data-mtr-content=\"Value\"><div class=\"mtr-cell-content\"> 7 <\/div><\/td><td class=\"mtr-td-tag\" data-tve-custom-colour=\"48971731\" data-mtr-content=\"Description\"><div class=\"mtr-cell-content\"> HAYIR<\/div><\/td><\/tr><\/tbody><\/table><h2> Excel&#8217;de VBA Mesaj Kutusu \u0130\u015flevini Kullanman\u0131n Ger\u00e7ek D\u00fcnya \u00d6rnekleri<\/h2><p> Burada ger\u00e7ek hayattaki baz\u0131 VBA mesaj kutusu \u00f6rneklerini listeledim ve bu \u00f6rneklerin size onu kullanman\u0131z i\u00e7in ilham verece\u011finden eminim. <\/p><h3 style=\"font-size: 22px; margin-bottom: 15px !important; margin-top: 0px !important;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #1. VBA MsgBox ile makro \u00e7al\u0131\u015ft\u0131rma<\/h3><p> Art\u0131k msgbox fonksiyonunun yard\u0131m\u0131yla, bir makroyu \u00e7al\u0131\u015ft\u0131rmadan \u00f6nce kullan\u0131c\u0131ya soru sorabilirsiniz. Anlamak i\u00e7in a\u015fa\u011f\u0131daki makroya bakal\u0131m.<\/p><p> SaveThis() alt\u0131nda<\/p><p> Tamsay\u0131 Olarak Lo\u015f Sonu\u00e7<\/p><p> Sonu\u00e7 = MsgBox(\u201cBu dosyay\u0131 kaydetmek istiyor musunuz?\u201d, vbOKCancel)<\/p><p> Sonu\u00e7 = vbOK ise<\/p><p> ActiveWorkbook.Save<\/p><p> Altyaz\u0131 biti\u015fi <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/enregistrer-le-classeur-avec-vba-msgbox.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba msgbox ile \u00e7al\u0131\u015fma kitab\u0131n\u0131 kaydet\" width=\"237\" height=\"143\" data-attachment-id=\"14848\"><\/p><p> Kullan\u0131c\u0131dan \u00e7al\u0131\u015fma kitab\u0131n\u0131 kaydetmesini isteyebilirsiniz ve kullan\u0131c\u0131 Tamam d\u00fc\u011fmesini t\u0131klat\u0131rsa makro kodu \u00e7al\u0131\u015fma kitab\u0131n\u0131 kaydedecektir. <\/p><h3 style=\"margin-bottom: 15px !important; margin-top: 0px !important; font-size: 22px;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #2. Mesaj kutusuna tablo ekleme<\/h3><p> Mesaj kutusuna tablo halinde veri girmek i\u00e7in vbTab&#8217;\u0131 kullanabilirsiniz. Bu \u00f6rnekte tablo A1 h\u00fccresinden ba\u015flamaktad\u0131r. <\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-onglet-dans-vba-msgbox.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"333\" height=\"308\" data-attachment-id=\"14850\"><\/p><p> AddToMsgBox() alt\u0131nda<\/p><p> Dize Olarak Mesaj\u0131 Karart<\/p><p> int olarak dim r<\/p><p> int olarak c&#8217;yi k\u0131s<\/p><p> rc&#8217;yi int olarak k\u0131s<\/p><p> CC&#8217;yi int olarak k\u0131s<\/p><p> myRows&#8217;u Aral\u0131k Olarak Dimle<\/p><p> myColumns&#8217;\u0131 Aral\u0131k Olarak Karart<\/p><p> Mesaj = \u201c\u201d<\/p><p> MyRows = Aral\u0131k&#8217;\u0131 Ayarla(\u201cA:A\u201d)<\/p><p> myColumns&#8217;u Ayarla = Aral\u0131k(\u201c1:1\u201d)<\/p><p> rc = Application.CountA(myRows)<\/p><p> cc = Application.CountA(myColumns)<\/p><p> r = 1&#8217;den rc&#8217;ye i\u00e7in c = 1&#8217;den cc&#8217;ye<\/p><p> Mesaj = Mesaj ve H\u00fccreler(r, c).Metin<\/p><p> E\u011fer c &lt;= cc ise O zaman<\/p><p> Mesaj = Mesaj &amp; vbTab<\/p><p> sonraki cMsg = Mesaj &amp; vbCrLf<\/p><p> Sonraki r<\/p><p> Mesaj Kutusu Mesaj<\/p><p> Altyaz\u0131 biti\u015fi <\/p><h3 style=\"margin-bottom: 15px !important; margin-top: 0px !important; font-size: 22px;\" data-fontsize=\"18\" data-inline-fontsize=\"true\" data-inline-lineheight=\"true\" data-lineheight=\"27\"> #3. Bir dosyay\u0131 a\u00e7arken mesaj kutusunu g\u00f6ster<\/h3><p> A\u015fa\u011f\u0131daki makroya bakarsan\u0131z, \u00e7al\u0131\u015fma kitab\u0131 a\u00e7\u0131ld\u0131\u011f\u0131nda g\u00f6r\u00fcnt\u00fclenecek bir mesaj olu\u015fturmak i\u00e7in auto_open&#8217;\u0131 kulland\u0131m.<\/p><p> auto_open() alt\u0131nda<\/p><p> MsgBox &#8220;Exceladvisor&#8217;a ho\u015f geldiniz &amp; Bu dosyay\u0131 indirdi\u011finiz i\u00e7in te\u015fekk\u00fcr ederiz&#8221; _<\/p><p> + vbNewLine + vbNewLine + \u201cBurada MsgBox fonksiyonunun detayl\u0131 a\u00e7\u0131klamas\u0131n\u0131 bulacaks\u0131n\u0131z. \u00bb _<\/p><p> + vbNewLine + vbNewLine + \u201cVe di\u011fer harika \u015feylere de g\u00f6z atmay\u0131 unutmay\u0131n. \u00bb<\/p><p> Altyaz\u0131 biti\u015fi<\/p><h2 data-fontsize=\"26\" data-lineheight=\"39\"> Paket servis<\/h2><ol><li> Yard\u0131m d\u00fc\u011fmesini d\u00f6rd\u00fcnc\u00fc d\u00fc\u011fme olarak kullanmazsan\u0131z, mesaj kutusuna d\u00f6rt d\u00fc\u011fme ekleyemezsiniz.<\/li><li> Mesaj kutunuza yard\u0131m dosyas\u0131 olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki \u00f6rnek dosyaya ba\u015fvurabilirsiniz.<\/li><\/ol><h2 data-fontsize=\"28\" data-lineheight=\"42\"> \u00d6rnek dosya<\/h2><p> Bu konuda daha fazla bilgi edinmek i\u00e7in <a style=\"outline: none;\" spellcheck=\"false\" href=\"http:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/msgbox.zip\" rel=\"nofollow\" data-wpel-link=\"internal\" data-ms-editor=\"true\">bu \u00f6rnek dosyay\u0131 buradan indirin<\/a> .<\/p><h2 data-fontsize=\"26\" data-lineheight=\"39\"> \u00c7\u00f6z\u00fcm<\/h2><p> Mesaj kutusu yaln\u0131zca mesaj\u0131 iletmenize yard\u0131mc\u0131 olmakla kalmaz, ayn\u0131 zamanda kullan\u0131c\u0131 \u00fczerinde yarat\u0131c\u0131 bir izlenim b\u0131rak\u0131r. Onlara mesaj g\u00f6nderebilir ve basit bir yan\u0131t alabilirsiniz.<\/p><p> Ve dedi\u011fim gibi, e\u011fer VBA&#8217;da yeniyseniz mesaj kutusunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenmek en iyi \u015feylerden biridir. Umar\u0131m bu makale VBA&#8217;da uzmanla\u015fma hayalinize yakla\u015fman\u0131za yard\u0131mc\u0131 olmu\u015ftur, ama \u015fimdi bana bir \u015fey s\u00f6yleyin.<\/p><p> <em>MsgBox fonksiyonunun VBA&#8217;daki en haval\u0131 \u015feylerden biri oldu\u011funu mu d\u00fc\u015f\u00fcn\u00fcyorsunuz?<\/em><\/p><p> G\u00f6r\u00fc\u015flerinizi yorum k\u0131sm\u0131nda benimle payla\u015fmay\u0131 unutmay\u0131n, sizden haber almay\u0131 \u00e7ok isterim ve bu ipucunu arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n.<\/p><p> <strong>VBA hakk\u0131nda daha fazla bilgi edinin<\/strong><\/p><ul><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/\" data-wpel-link=\"internal\">VBA kullanarak ada sahip yeni sayfa ekleyin<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/\" data-wpel-link=\"internal\">Excel&#8217;de makro nas\u0131l kaydedilir<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/acik-secenek-2\/\" data-wpel-link=\"internal\">A\u00e7\u0131k VBA se\u00e7ene\u011fi<\/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-1842","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>Excel&#039;de mesaj kutusu i\u015flevleri nas\u0131l olu\u015fturulur?<\/title>\n<meta name=\"description\" content=\"VBA MsgBox, kullan\u0131c\u0131ya mesaj iletmek ve kullan\u0131c\u0131dan yan\u0131t almak i\u00e7in kullan\u0131lan basit bir a\u00e7\u0131l\u0131r penceredir\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de mesaj kutusu i\u015flevleri nas\u0131l olu\u015fturulur?\" \/>\n<meta property=\"og:description\" content=\"VBA MsgBox, kullan\u0131c\u0131ya mesaj iletmek ve kullan\u0131c\u0131dan yan\u0131t almak i\u00e7in kullan\u0131lan basit bir a\u00e7\u0131l\u0131r penceredir\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.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=\"9 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/\",\"name\":\"Excel&#39;de mesaj kutusu i\u015flevleri nas\u0131l olu\u015fturulur?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png\",\"datePublished\":\"2023-10-31T18:23:37+00:00\",\"dateModified\":\"2023-12-10T06:01:37+00:00\",\"description\":\"VBA MsgBox, kullan\u0131c\u0131ya mesaj iletmek ve kullan\u0131c\u0131dan yan\u0131t almak i\u00e7in kullan\u0131lan basit bir a\u00e7\u0131l\u0131r penceredir\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de mesaj kutusu i\u015flevleri 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":"Excel&#39;de mesaj kutusu i\u015flevleri nas\u0131l olu\u015fturulur?","description":"VBA MsgBox, kullan\u0131c\u0131ya mesaj iletmek ve kullan\u0131c\u0131dan yan\u0131t almak i\u00e7in kullan\u0131lan basit bir a\u00e7\u0131l\u0131r penceredir","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de mesaj kutusu i\u015flevleri nas\u0131l olu\u015fturulur?","og_description":"VBA MsgBox, kullan\u0131c\u0131ya mesaj iletmek ve kullan\u0131c\u0131dan yan\u0131t almak i\u00e7in kullan\u0131lan basit bir a\u00e7\u0131l\u0131r penceredir","og_url":"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:37+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"9 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/","url":"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/","name":"Excel&#39;de mesaj kutusu i\u015flevleri nas\u0131l olu\u015fturulur?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png","datePublished":"2023-10-31T18:23:37+00:00","dateModified":"2023-12-10T06:01:37+00:00","description":"VBA MsgBox, kullan\u0131c\u0131ya mesaj iletmek ve kullan\u0131c\u0131dan yan\u0131t almak i\u00e7in kullan\u0131lan basit bir a\u00e7\u0131l\u0131r penceredir","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/syntaxe-fonction-vba-msgbox.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de mesaj kutusu i\u015flevleri 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\/1842","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=1842"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1842\/revisions"}],"predecessor-version":[{"id":2544,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1842\/revisions\/2544"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}