{"id":211,"date":"2018-10-02T23:58:05","date_gmt":"2018-10-02T20:58:05","guid":{"rendered":"http:\/\/www.cuneytbayrak.com\/?p=211"},"modified":"2025-02-20T23:58:32","modified_gmt":"2025-02-20T20:58:32","slug":"vba-textbox-keyup-keydown-kontrol","status":"publish","type":"post","link":"http:\/\/www.cuneytbayrak.com\/?p=211","title":{"rendered":"VBA TextBox KeyUp-KeyDown Kontrol"},"content":{"rendered":"<p>Formunuzda kulland\u0131\u011f\u0131n\u0131z TextBox\u2019\u0131 up ve down tu\u015flar\u0131 ile kontrol etmek isteyebilirsiniz. Mesela TextBox\u2019da ki say\u0131lar\u0131 yukar\u0131 ok tu\u015funa basarak art\u0131r\u0131p a\u015fa\u011f\u0131 ok tu\u015funa basarak d\u00fc\u015f\u00fcrmek isteyebilirsiniz. Bu durum da a\u015fa\u011f\u0131da ki kodlar\u0131 inceleyin. Faydal\u0131 olacakt\u0131r.<\/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 TextBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)\r\nIf TextBox1.Value = \"\" And KeyCode = vbKeyUp Then\r\nTextBox1.Value = 1\r\nExit Sub\r\nEnd If\r\nIf KeyCode = vbKeyDown Then\r\nTextBox1.Value = TextBox1.Value - 1\r\nEnd If\r\nIf KeyCode = vbKeyUp Then\r\nTextBox1.Value = TextBox1.Value + 1\r\nEnd If\r\nEnd Sub<\/pre>\n<\/div>\n<p>Kolay gele&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Formunuzda kulland\u0131\u011f\u0131n\u0131z TextBox\u2019\u0131 up ve down tu\u015flar\u0131 ile kontrol etmek isteyebilirsiniz. Mesela TextBox\u2019da ki say\u0131lar\u0131 yukar\u0131 ok tu\u015funa basarak art\u0131r\u0131p a\u015fa\u011f\u0131 ok tu\u015funa basarak d\u00fc\u015f\u00fcrmek isteyebilirsiniz. Bu durum da a\u015fa\u011f\u0131da&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"http:\/\/www.cuneytbayrak.com\/?p=211\">Devam\u0131n\u0131 Oku<span class=\"screen-reader-text\">VBA TextBox KeyUp-KeyDown Kontrol<\/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":[66],"class_list":["post-211","post","type-post","status-publish","format-standard","hentry","category-excel-vba","tag-textboxkeyupkeydown","excerpt"],"_links":{"self":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/211","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=211"}],"version-history":[{"count":1,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/211\/revisions"}],"predecessor-version":[{"id":213,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/211\/revisions\/213"}],"wp:attachment":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=211"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}