{"id":176,"date":"2022-05-20T22:49:43","date_gmt":"2022-05-20T19:49:43","guid":{"rendered":"http:\/\/www.cuneytbayrak.com\/?p=176"},"modified":"2025-02-20T22:50:00","modified_gmt":"2025-02-20T19:50:00","slug":"vba-combobox-icine-mudahele-ettirmemek","status":"publish","type":"post","link":"http:\/\/www.cuneytbayrak.com\/?p=176","title":{"rendered":"VBA ComboBox \u0130\u00e7ine M\u00fcdahele Ettirmemek"},"content":{"rendered":"<p>ComboBox i\u00e7ine veriyi, AddItem ile yada herhangi bir db den veri \u00e7ekerek doldurdu\u011fumuz durumlarda, kullan\u0131c\u0131 taraf\u0131ndan veri yaz\u0131lmamas\u0131n\u0131 istersek \u015fayet;<\/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 ComboBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)\r\n \r\nIf KeyCode = 8 Or KeyCode = vbKeyDelete Then\r\nKeyCode = 0\r\nEnd If\r\n \r\nEnd Sub<\/pre>\n<\/div>\n<p>ve\u2026..<\/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 ComboBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)\r\n \r\nKeyAscii = 0\r\n \r\nEnd Sub<\/pre>\n<\/div>\n<p>Neden KeyPress ve KeyDown\u2019a ayr\u0131 ayr\u0131 kod yaz\u0131ld\u0131 ehli anlars\u0131n.<\/p>\n<p>Kolay gele&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>ComboBox i\u00e7ine veriyi, AddItem ile yada herhangi bir db den veri \u00e7ekerek doldurdu\u011fumuz durumlarda, kullan\u0131c\u0131 taraf\u0131ndan veri yaz\u0131lmamas\u0131n\u0131 istersek \u015fayet; Private Sub ComboBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"http:\/\/www.cuneytbayrak.com\/?p=176\">Devam\u0131n\u0131 Oku<span class=\"screen-reader-text\">VBA ComboBox \u0130\u00e7ine M\u00fcdahele Ettirmemek<\/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":0,"footnotes":""},"categories":[5],"tags":[47],"class_list":["post-176","post","type-post","status-publish","format-standard","hentry","category-excel-vba","tag-comboboxnotselect","excerpt"],"_links":{"self":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/176","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=176"}],"version-history":[{"count":1,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/176\/revisions"}],"predecessor-version":[{"id":177,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/176\/revisions\/177"}],"wp:attachment":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=176"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}