{"id":12073,"date":"2011-10-15T18:34:53","date_gmt":"2011-10-15T18:34:53","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=105"},"modified":"2018-06-18T11:05:12","modified_gmt":"2018-06-18T11:05:12","slug":"getting-started-with-excel-macro-2","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/","title":{"rendered":"Excel Macro Tutorial : How to add different types of controls like Text Box, Radio button, button etc. in Excel"},"content":{"rendered":"<p>Dear Readers,<\/p>\n<p>This is the 3rd Article of this <strong> <a href=\"https:\/\/vmlogger.com\/excel\/excel-macro-for-beginners\/\" target=\"_blank\">Excel Macro Tutorial<\/a><\/strong>. In this Article, we are going to see <strong>How to add different types of controls like Text Box, Radio button, button etc. in to the Excel<\/strong><br \/>\n&nbsp;<\/p>\n<p>Follow the below Steps one-by-one to Add Controls in your Excel Workbook or <strong><a href=\"https:\/\/vmlogger.com\/excel\/2016\/10\/video-tutorial-how-to-add-controls-like-command-button-in-excel-for-beginners\/\" target=\"_blank\" >else watch my Video tutorial here<\/a><\/strong>:<br \/>\n&nbsp;<\/p>\n<p>1. Go to the Developer Tab (<a title=\"How to add Developer Tab in Excel-2010 and 2007 Workbook\" href=\"https:\/\/vmlogger.com\/excel\/2011\/10\/add-developer-tab-in-excel-2010-and-2007\/\" target=\"_blank\">How to Add Developer Tab in Excel 2007 or 2010<\/a>)<br \/>\n2. Click on \u201cInsert\u201d arrow link<br \/>\n3. Form Controls and ActiveX Control<br \/>\n4. Whichever control you want to add in the Excel Sheet, just click on that control<\/p>\n<p><\/p>\n<p><a href=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/10\/Macro-Tools.jpg\"><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/10\/Macro-Tools.jpg\" alt=\"Excel Macro Tutorial : Excel Macro Controls 1\" title=\"Macro Tools\" class=\"aligncenter size-full wp-image-106\" \/><\/a><\/p>\n<p><\/p>\n<p>5. Now click on the place where you want to be that control<br \/>\n6. Your control will be placed at that place. Now you can drag that control wherever you want and also you can adjust the size of that control.<br \/>\n<\/p>\n<div id=\"attachment_1442\" style=\"width: 493px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/10\/Add-Controls.png\"><img decoding=\"async\" aria-describedby=\"caption-attachment-1442\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/10\/Add-Controls.png\" alt=\"Excel Macro Tutorial : Add-Controls\" title=\"Excel Macro Tutorial : Add-Controls\" width=\"483\" height=\"330\" class=\"size-full wp-image-1442\" \/><\/a><p id=\"caption-attachment-1442\" class=\"wp-caption-text\">Excel Macro Tutorial : Add-Controls<\/p><\/div>\n<p><\/p>\n<table bgcolor=#EBDDE2 width=100%>\n<tr>\n<td>\n&nbsp;<br \/>\nTo Check out more Excel Macro Tutorials, visit <strong><a href=\"https:\/\/vmlogger.com\/excel\/excel-macro-for-beginners\/\" target=\"_blank\">Excel Macro Tutorial<\/a><\/strong><br \/>\n\n<\/td>\n<\/tr>\n<\/table>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>Dear Readers, This is the 3rd Article of this Excel Macro Tutorial. In this Article, we are going to see How to add different types of controls like Text Box, Radio button, button etc. in to the Excel &nbsp; Follow the below Steps one-by-one to Add Controls in your Excel Workbook or else watch my [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":0,"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-12073","post","type-post","status-publish","format-standard","hentry","category-excel-macro-beginner"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.5 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel Macro Tutorial : How to add different types of controls like Text Box, Radio button, button etc. in Excel - Let&#039;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\/10\/getting-started-with-excel-macro-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Macro Tutorial : How to add different types of controls like Text Box, Radio button, button etc. in Excel\" \/>\n<meta property=\"og:description\" content=\"Dear Readers, This is the 3rd Article of this Excel Macro Tutorial. In this Article, we are going to see How to add different types of controls like Text Box, Radio button, button etc. in to the Excel &nbsp; Follow the below Steps one-by-one to Add Controls in your Excel Workbook or else watch my [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Let&#039;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-10-15T18:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-06-18T11:05:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/10\/Macro-Tools.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"671\" \/>\n\t<meta property=\"og:image:height\" content=\"238\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Excel Macro Tutorial : How to add different types of controls like Text Box, Radio button, button etc. in Excel\",\"datePublished\":\"2011-10-15T18:34:53+00:00\",\"dateModified\":\"2018-06-18T11:05:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/\"},\"wordCount\":179,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/10\/Macro-Tools.jpg\",\"articleSection\":[\"Excel Macro Beginner\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/\",\"name\":\"Excel Macro Tutorial : How to add different types of controls like Text Box, Radio button, button etc. in Excel - Let&#039;s excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/10\/Macro-Tools.jpg\",\"datePublished\":\"2011-10-15T18:34:53+00:00\",\"dateModified\":\"2018-06-18T11:05:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/10\/Macro-Tools.jpg\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/10\/Macro-Tools.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/#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 : How to add different types of controls like Text Box, Radio button, button etc. in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let&#039;s excel in Excel\",\"description\":\"Let&#039;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 &amp; 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 : How to add different types of controls like Text Box, Radio button, button etc. in Excel - Let&#039;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\/10\/getting-started-with-excel-macro-2\/","og_locale":"en_US","og_type":"article","og_title":"Excel Macro Tutorial : How to add different types of controls like Text Box, Radio button, button etc. in Excel","og_description":"Dear Readers, This is the 3rd Article of this Excel Macro Tutorial. In this Article, we are going to see How to add different types of controls like Text Box, Radio button, button etc. in to the Excel &nbsp; Follow the below Steps one-by-one to Add Controls in your Excel Workbook or else watch my [&hellip;]","og_url":"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/","og_site_name":"Let&#039;s excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2011-10-15T18:34:53+00:00","article_modified_time":"2018-06-18T11:05:12+00:00","og_image":[{"width":671,"height":238,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/10\/Macro-Tools.jpg","type":"image\/jpeg"}],"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":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Excel Macro Tutorial : How to add different types of controls like Text Box, Radio button, button etc. in Excel","datePublished":"2011-10-15T18:34:53+00:00","dateModified":"2018-06-18T11:05:12+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/"},"wordCount":179,"commentCount":1,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/10\/Macro-Tools.jpg","articleSection":["Excel Macro Beginner"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/","url":"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/","name":"Excel Macro Tutorial : How to add different types of controls like Text Box, Radio button, button etc. in Excel - Let&#039;s excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/10\/Macro-Tools.jpg","datePublished":"2011-10-15T18:34:53+00:00","dateModified":"2018-06-18T11:05:12+00:00","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/10\/Macro-Tools.jpg","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/10\/Macro-Tools.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/getting-started-with-excel-macro-2\/#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 : How to add different types of controls like Text Box, Radio button, button etc. in Excel"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let&#039;s excel in Excel","description":"Let&#039;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 &amp; 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\/12073"}],"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=12073"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12073\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12073"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12073"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}