{"id":232,"date":"2016-05-11T00:15:54","date_gmt":"2016-05-10T21:15:54","guid":{"rendered":"http:\/\/www.cuneytbayrak.com\/?p=232"},"modified":"2025-02-21T00:18:22","modified_gmt":"2025-02-20T21:18:22","slug":"vba-ile-excel-verisi-refresh-etme","status":"publish","type":"post","link":"http:\/\/www.cuneytbayrak.com\/?p=232","title":{"rendered":"VBA Userform\u2019u X i\u015faretinden kapatma \u00f6zelli\u011fini pasif yapma"},"content":{"rendered":"<p>Diyelim ki a\u015fa\u011f\u0131da resimde g\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi bir userformunuz var ve siz sadece \u201cKAPAT\u201d butonuna basarak formun kapanmas\u0131n\u0131 istiyorsunuz. formun sa\u011f \u00fcst k\u00f6\u015fesinde ki \u201cX\u201d i\u015fareti ile kapanmas\u0131n\u0131 engellemeniz gerekmektedir. A\u015fa\u011f\u0131da ki kodlar\u0131 kullanabilirsiniz.<\/p>\n<div class=\"wp-block-codemirror-blocks code-block \">\n<pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;vb&quot;,&quot;mime&quot;:&quot;text\/x-vb&quot;,&quot;theme&quot;:&quot;material&quot;,&quot;lineNumbers&quot;:true,&quot;lineWrapping&quot;:false,&quot;styleActiveLine&quot;:false,&quot;readOnly&quot;:true,&quot;align&quot;:&quot;&quot;}\">Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)\r\nIf CloseMode = 0 Then Cancel = True\r\nEnd Sub<\/pre>\n<\/div>\n<p>Cancel=True ifadesini False yaparsan\u0131z tekrar \u201cX\u201d i\u015faretinden formu kapatabilirsiniz.<\/p>\n<p>Kolay gele&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Diyelim ki a\u015fa\u011f\u0131da resimde g\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi bir userformunuz var ve siz sadece \u201cKAPAT\u201d butonuna basarak formun kapanmas\u0131n\u0131 istiyorsunuz. formun sa\u011f \u00fcst k\u00f6\u015fesinde ki \u201cX\u201d i\u015fareti ile kapanmas\u0131n\u0131 engellemeniz gerekmektedir. A\u015fa\u011f\u0131da&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"http:\/\/www.cuneytbayrak.com\/?p=232\">Devam\u0131n\u0131 Oku<span class=\"screen-reader-text\">VBA Userform\u2019u X i\u015faretinden kapatma \u00f6zelli\u011fini pasif yapma<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":2,"footnotes":""},"categories":[5],"tags":[77],"class_list":["post-232","post","type-post","status-publish","format-standard","hentry","category-excel-vba","tag-formclosenotusing","excerpt"],"_links":{"self":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=232"}],"version-history":[{"count":3,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/232\/revisions"}],"predecessor-version":[{"id":237,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/232\/revisions\/237"}],"wp:attachment":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=232"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}