{"id":215,"date":"2018-10-02T00:00:17","date_gmt":"2018-10-01T21:00:17","guid":{"rendered":"http:\/\/www.cuneytbayrak.com\/?p=215"},"modified":"2025-02-21T00:01:25","modified_gmt":"2025-02-20T21:01:25","slug":"vba-userform-kontrol-nesnelerine-dongu-ile-mudahele-etme","status":"publish","type":"post","link":"http:\/\/www.cuneytbayrak.com\/?p=215","title":{"rendered":"VBA UserForm Kontrol Nesnelerine D\u00f6ng\u00fc ile Mudahele Etme"},"content":{"rendered":"<p>Projelerinizde birden fazla kontrol nesneleri vard\u0131r. Bazen bu nesnelerin tamam\u0131 \u00fczerinde ayn\u0131 i\u015flem yapman\u0131z gerekebilir. Bu durumda her bir kontrol nesnesi i\u00e7in ayr\u0131 ayr\u0131 kod yazmaktansa bir d\u00f6ng\u00fc ile istedi\u011finiz i\u015flemi yapmak daha mant\u0131kl\u0131d\u0131r ve sizi kod kalabal\u0131\u011f\u0131ndan kurtar\u0131r. A\u015fa\u011f\u0131da ki kodlar\u0131 inceleyin. Anla\u015f\u0131lacakt\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 UserForm_Activate()\r\nDim obj As Control\r\n \r\nFor Each obj In UserForm6.Controls\r\nIf TypeName(obj) = \"ComboBox\" Then\r\nobj.Style = fmStyleDropDownList\r\nEnd If\r\nNext obj\r\n \r\nEnd Sub<\/pre>\n<\/div>\n<p>Kolay gele&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Projelerinizde birden fazla kontrol nesneleri vard\u0131r. Bazen bu nesnelerin tamam\u0131 \u00fczerinde ayn\u0131 i\u015flem yapman\u0131z gerekebilir. Bu durumda her bir kontrol nesnesi i\u00e7in ayr\u0131 ayr\u0131 kod yazmaktansa bir d\u00f6ng\u00fc ile istedi\u011finiz&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"http:\/\/www.cuneytbayrak.com\/?p=215\">Devam\u0131n\u0131 Oku<span class=\"screen-reader-text\">VBA UserForm Kontrol Nesnelerine D\u00f6ng\u00fc ile Mudahele Etme<\/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":[67],"class_list":["post-215","post","type-post","status-publish","format-standard","hentry","category-excel-vba","tag-controlobjectloop","excerpt"],"_links":{"self":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/215","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=215"}],"version-history":[{"count":1,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/215\/revisions"}],"predecessor-version":[{"id":216,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/215\/revisions\/216"}],"wp:attachment":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=215"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}