{"id":12100,"date":"2011-12-04T11:50:30","date_gmt":"2011-12-04T11:50:30","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=867"},"modified":"2011-12-04T11:50:30","modified_gmt":"2011-12-04T11:50:30","slug":"properties-window-in-the-visual-basic-editor-of-excel","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/","title":{"rendered":"Excel Macro Tutorial : VBA Control Property"},"content":{"rendered":"

In last post Excel Macro Tutorial : Visual Basic Editor in Excel<\/a><\/strong> we saw how to add different Controls in your Excel Macro. To Read All the Excel Macro Tutorial Click Here<\/a><\/strong>.
\n 
\nEach and Every VBA controls has their own by default properties. Like Name of the Control, height, width, Caption, color, background, font color etc. In Excel other than All these VBA controls like Command Button, Radio Button, Textbox etc. Worksheets also has its own properties.
\n 
\nSo let’s see how we can see and change the properties of a control added in your excel Sheet.
\n<\/p>\n

Step 1.<\/strong> In below Excel Sheet we have 2 controls, 1 Command Button and One Combobox
\n
\n

<\/a>

Command Button and Combobox<\/p><\/div>
\n
\nPress Right Click on the Control for which you want see or change the Properties of that Control.
\n 
\nStep 2.<\/strong> Click on Properties
\n
\n\"properties-window\"
\n
\nStep 3.<\/strong> Property Window is visible now. On top you can see all the Controls added to your Sheet along with the Sheet Name. By default that control will be selected on which you had right clicked and selected the “Properties”. From here you can select any of the Control for which you want to view the Property.
\n
\n\"properties-window\"
\n
\nStep 4. For Example: <\/strong>In the above Picture you can see Property of the CommandButton1 is displayed.
\n
\n\"properties-window\"
\n
\nOn Top you can see there is a Property called “Name”. This is the Name of that Control. This should always be unique in the Excel Workbook as each and Every Control is uniquely identified by this name.
\nWhen you add a new Control is added to the Sheet, by default a unique name is given to that control like RadioButton1, RadioButton2 etc.
\n
\nIt is always a good habit to change the name of your Controls based on it’s functionality. So that when you have lot’s of controls then it’s easy to remember the control names while writing code.<\/p>\n

<\/p>\n

Similarly you can Change following ActiveX Control Properties:<\/strong>
\n
\n1. VBA Textbox Property
\n2. VBA Combobox Property
\n3. VBA CheckBox Property
\n4. VBA ListBox Property
\n5. VBA ScrollBar Property
\n6. VBA Spin Button Property
\n7. VBA Radio Button Property (Option Button property)
\n8. VBA Label Property
\n9. VBA Toggle Button Property<\/p>\n

……. and so many other ActiveX Controls<\/p>\n

\nNote:<\/strong> Here I have not given Screen Shots and Steps for all the Properties of all the Controls. But if you are facing any issues in Properties of any Control or any other Issues or Solution related to Excel, just Give a reply to this post with your doubt or question<\/strong> or email me at Info@learnexcelmacro.com<\/a><\/strong><\/i>
\n<\/p>\n\n\n
\n 
\nTo Check out more Excel Macro Tutorials, visit Excel Macro Tutorial<\/a><\/strong>
\n\n<\/td>\n<\/tr>\n<\/table>\n<\/span>","protected":false},"excerpt":{"rendered":"

In last post Excel Macro Tutorial : Visual Basic Editor in Excel we saw how to add different Controls in your Excel Macro. To Read All the Excel Macro Tutorial Click Here.   Each and Every VBA controls has their own by default properties. Like Name of the Control, height, width, Caption, color, background, font […]<\/p>\n","protected":false},"author":45,"featured_media":869,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1679],"tags":[],"class_list":["post-12100","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-macro-beginner"],"yoast_head":"\nExcel Macro Tutorial : VBA Control Property - Let's excel in Excel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Macro Tutorial : VBA Control Property\" \/>\n<meta property=\"og:description\" content=\"In last post Excel Macro Tutorial : Visual Basic Editor in Excel we saw how to add different Controls in your Excel Macro. To Read All the Excel Macro Tutorial Click Here.   Each and Every VBA controls has their own by default properties. Like Name of the Control, height, width, Caption, color, background, font […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2011-12-04T11:50:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Excel Macro Tutorial : VBA Control Property\",\"datePublished\":\"2011-12-04T11:50:30+00:00\",\"dateModified\":\"2011-12-04T11:50:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/\"},\"wordCount\":442,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/#primaryimage\"},\"thumbnailUrl\":\"\",\"articleSection\":[\"Excel Macro Beginner\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/\",\"name\":\"Excel Macro Tutorial : VBA Control Property - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/#primaryimage\"},\"thumbnailUrl\":\"\",\"datePublished\":\"2011-12-04T11:50:30+00:00\",\"dateModified\":\"2011-12-04T11:50:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro Beginner\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-macro-beginner\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Macro Tutorial : VBA Control Property\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel Macro Tutorial : VBA Control Property - Let's excel in Excel","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:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/","og_locale":"en_US","og_type":"article","og_title":"Excel Macro Tutorial : VBA Control Property","og_description":"In last post Excel Macro Tutorial : Visual Basic Editor in Excel we saw how to add different Controls in your Excel Macro. To Read All the Excel Macro Tutorial Click Here.   Each and Every VBA controls has their own by default properties. Like Name of the Control, height, width, Caption, color, background, font […]","og_url":"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2011-12-04T11:50:30+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png","type":"image\/png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Excel Macro Tutorial : VBA Control Property","datePublished":"2011-12-04T11:50:30+00:00","dateModified":"2011-12-04T11:50:30+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/"},"wordCount":442,"commentCount":2,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/#primaryimage"},"thumbnailUrl":"","articleSection":["Excel Macro Beginner"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/","url":"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/","name":"Excel Macro Tutorial : VBA Control Property - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/#primaryimage"},"thumbnailUrl":"","datePublished":"2011-12-04T11:50:30+00:00","dateModified":"2011-12-04T11:50:30+00:00","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/properties-window-in-the-visual-basic-editor-of-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro Beginner","item":"https:\/\/vmlogger.com\/excel\/excel-macro-beginner\/"},{"@type":"ListItem","position":3,"name":"Excel Macro Tutorial : VBA Control Property"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12100"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12100"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12100\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}