{"id":12131,"date":"2012-03-25T08:46:00","date_gmt":"2012-03-25T08:46:00","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1491"},"modified":"2022-08-07T00:25:29","modified_gmt":"2022-08-07T00:25:29","slug":"excel-macro-tutorial-combobox-in-excel-macro","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/","title":{"rendered":"Excel Macro Tutorial : ComboBox in Excel Macro"},"content":{"rendered":"

It’s been a long time since I posted an article :(. Today I am going to write about Combo Box in Excel. At the end of this Article, you will be able to use Drop down in Excel. It will include
\n 
\n1. Adding Items in Excel Combobox dor Excel Drop Down
\n2. Removing Items from Drop down
\n3. Removing All items from Drop Down
\n4. Selecting options from Drop down by position in the drop down
\n5. Selecting options from Drop down by Value of the option in the drop down
\n6. Excel Drop Down Default Value
\n7. How to get the Total Count of Items in a Combobox
\n 
\n…..and many more<\/strong> things about Excel Combobox.
\n
\nFirst will learn how to place Drop Down or Combobox in your Excel Sheet.
\nBy going to Developer Tab –> Insert –> Combo Box Activex Control<\/strong><\/p>\n

\"Excel

Excel Macro Tutorial – Add Combo Box 1<\/p><\/div>
\nNow Drag and Drop that Control any where you want in your Spreadsheet.
\nYou can Also re-size the Height and Width etc keeping it in Design Mode<\/p>\n

\"Excel

Excel Macro Tutorial – Combo Box in Design Mode<\/p><\/div>\n

Now as you can see that Drop Down is created in the Sheet, you will learn How to Add Options or Items in the Drop down.<\/strong> As of Now it is completely blank. There is no option\/item in it.
\nBasically there are two ways of Adding list Items in Drop Down List. 1. By Setting Range Formula in the Properties of Combo Box.
\n 
\n2. By using Excel VBA Code<\/strong>
\n<\/p>\n

Add List Items in Drop Down by Using Properties: <\/h3>\n

To Add items by setting Properties of the Combo Box, follow the below Steps:
\n 
\n Step 1.<\/strong> Select the Combo Box Control and Right Click and Open the Properties Window
\n Step 2.<\/strong> Now Enter the Cell Range in ListFillRange<\/strong> Property as shown below:<\/p>\n

\"Excel

Excel Macro Tutorial – Combo Box – ListFillRange Property<\/p><\/div>
\nNow whatever List Items you want to be there in the Drop Down, Type them in that Range in Excel Sheet. All the list available in that Range will start appearing in the Drop Down as shown below:<\/p>\n

\"Excel

Excel Macro Tutorial – Drop Down List in Excel<\/p><\/div>\n

Add List Items in Drop Down by Using Excel Macro (VBA Code): <\/h3>\n

In Drop Down List Box, all the Items are by default Indexed from 0, 1, 2 etc. The first item which is added to Drop Down List will be indexed as 0, Second One will be Indexed as 1 and so on.. Therefore no need of any indexing here while adding list items in the Drop Down List.
\nTo Add Item List in Drop Down List, there is a very Simple VBA Syntax as shown Below:
\n 
\n<ComboBoxName>.AddItem <List Item> , <Index Number ><\/strong>
\n <\/p>\n

\r\nSub Insert_Item_List()\r\n\r\nSheet1.ComboBox1.AddItem \"Option 1\", 0\r\nSheet1.ComboBox1.AddItem \"Option 2\", 1\r\nSheet1.ComboBox1.AddItem \"Option 3\", 2\r\nSheet1.ComboBox1.AddItem \"Option 4\", 3\r\nSheet1.ComboBox1.AddItem \"Option 5\", 4\r\n\r\nEnd Sub\r\n\r\n<\/code><\/pre>\n
In the Above Code, Sheet1<\/strong> is the Sheet Name where Combobox is there and ComboBox1<\/strong> is the Name of the ComboBox Control.
\n
\nImportant:<\/strong>
\nIn Combobox, when you are adding a New Item, It always gets added at the End of the List Which are already assigned to that Drop Down List. It means, It always appends the items to the list. So Every time you want a fresh List of Items in your Drop down, then before adding any new Item, Clear all the Existing Items from the Drop Down. Below is the Code How to Clear All the Items from the Drop Down List<\/strong>
\n <\/p>\n\n\n
\n 
\nSheet1.ComboBox1.Clear
\n \n<\/td>\n<\/tr>\n<\/table>\n
Most of the time you add List Items dynamically. For Example:<\/strong> you have some list of Values stored in an Array Variable and you want all of them to Add in the Drop Down List. In the below Code, you will learn how to Add List Items from an Array Variable using For loop.<\/p>\n
\r\n\r\nSub Insert_Item_List()\r\n\r\nDim iCounter As Integer\r\nDim Item(10) As String\r\n'Store 10 List Items in an Array Variable\r\nFor i = 0 To 9\r\n  Item(i) = \"Option \" & i + 1\r\nNext\r\n'Now Add all these items from Array Variable to Combo Box\r\nFor i = 0 To 9\r\n  Sheet1.ComboBox1.AddItem Item(i)\r\nNext\r\nEnd Sub\r\n<\/code><\/pre>\n
Take the Above Code and Paste it in a Regular Module and Run it after adding a Combobox in your Sheet. It will Add 10 Items in the Drop down from “Option 1” to “Option 10”.<\/strong> But there is a problem in Above code. If you run the same Code twice, in your Drop down there will be 20 list get added, if you run thrice then 30 and so on. Why? because as i told earlier that .AddItem<\/strong> always append the list. It does not clear the Previous ones and then add the new one. To overcome this Problem, we need to put a Statement to Clear all the Items before you add list in the Drop Down list box. Therefore in the below code, this problem will not occur.<\/p>\n
\r\n\r\nSub Insert_Item_List()\r\n\r\nDim iCounter As Integer\r\nDim Item(10) As String\r\n'Store 10 List Items in an Array Variable\r\nFor i = 0 To 9\r\n  Item(i) = \"Option \" & i + 1\r\nNext\r\n'Before Adding items to the List, Clear the Drop Down Box\r\n  Sheet1.ComboBox1.Clear\r\n'Now Add all these items from Array Variable to Combo Box\r\nFor i = 0 To 9\r\n  Sheet1.ComboBox1.AddItem Item(i)\r\nNext\r\nEnd Sub\r\n\r\n<\/code><\/pre>\n
\nAs you saw how to Clear or Remove All the Items from the Drop down.<\/strong> Now you will learn how to remove a particular Item from Drop Down List<\/strong><\/p>\n
If you want to Remove a particular Item from the Drop Down then use the below code to remove item from the Drop Down List. For Removing an Item, you need to pass Index Number as an Input Parameter.<\/p>\n
 
\n<ComboBoxName>.RemoveItem <Index Number ><\/strong>
\n <\/p>\n
\r\n\r\nSheet1.ComboBox1.RemoveItem 0\r\n\r\n<\/code><\/pre>\n
The Above Code will Always Remove the First List Item from the Drop Down.
\n<\/p>\n
 How to Select First List Item as by Default: <\/h3>\n
 As you can see by default no List value is selected after adding items. If you want to make Some List Item as Default One then follow the below.
\n 
\n<ComboBoxName>.ListIndex= <Index Number ><\/strong>
\n 
\nTo select an Item from the Drop Down you need to use the below Code
\n <\/p>\n
\r\n\r\nSheet1.ComboBox1.ListIndex = 0\r\n\r\n<\/code><\/pre>\n
 
\nIn the Above example, First Item will be by default selected as I have used the Index Number as Zero (0). Similarly if you want to Select second or Third… give the Index Number of that Item.
\n
\n Want to Select Blank Option in Drop Down Box: <\/strong> To Select Blank Option from the Drop Down List, you should use Index Number as -1<\/strong>.
\n <\/p>\n
\r\n\r\nSheet1.ComboBox1.ListIndex = -1\r\n\r\n<\/code><\/pre>\n
\n If you want to Select the Last Item of the Drop Down List By default, then use the below Code:<\/strong>
\n <\/p>\n
\r\n\r\nSheet1.ComboBox1.ListIndex = Sheet1.ComboBox1.ListCount - 1\r\n\r\n<\/code><\/pre>\n
<\/p>\n
How to Get Selected Value of the Drop Down List: <\/h3>\n
Below is the Simple Code which will show you how to get the Selected Value of the Drop Down. .Value <\/strong> property of the Control ComboBox1<\/strong> returns the Selected Value of the Drop Down.<\/p>\n
 <\/p>\n
\r\n\r\nMsgBox \"Selected Value is\" & ComboBox1.Value\r\n\r\n<\/code><\/pre>\n
<\/p>\n
How to Get Total Count of Items in a ComboBox<\/h3>\n
 .ListCount<\/strong> is a Property in Of ComboBox object to get the Total Number of Items in a ComboBox. .ListCount<\/strong> always returns a Number.
\nRefer the Below Code. It will give the the Total Number of Items in the ListBox1<\/strong>
\n<\/p>\n
\r\nMsgBox (ComboBox1.ListCount)\r\n<\/code><\/pre>\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":"
It’s been a long time since I posted an article :(. Today I am going to write about Combo Box in Excel. At the end of this Article, you will be able to use Drop down in Excel. It will include   1. Adding Items in Excel Combobox dor Excel Drop Down 2. Removing Items […]<\/p>\n","protected":false},"author":45,"featured_media":242544,"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":[1675],"tags":[],"class_list":["post-12131","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-macro-for-beginners"],"yoast_head":"\nExcel Macro Tutorial : ComboBox in Excel Macro - Let's excel in Excel<\/title>\n<meta name=\"description\" content=\"Excel Macro Tutorial : How to Add Drop Down List in Excel? How to Add list Items in Combo Box? How to Remove Items from Drop Down? How to Select first Item as Default Value in Drop Down? How to remove All items from the Drop Down?\" \/>\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\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Macro Tutorial : ComboBox in Excel Macro\" \/>\n<meta property=\"og:description\" content=\"Excel Macro Tutorial : How to Add Drop Down List in Excel? How to Add list Items in Combo Box? How to Remove Items from Drop Down? How to Select first Item as Default Value in Drop Down? How to remove All items from the Drop Down?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/\" \/>\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=\"2012-03-25T08:46:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-07T00:25:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/03\/Combo-box-in-excel-vba.png\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"250\" \/>\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=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Excel Macro Tutorial : ComboBox in Excel Macro\",\"datePublished\":\"2012-03-25T08:46:00+00:00\",\"dateModified\":\"2022-08-07T00:25:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/\"},\"wordCount\":1123,\"commentCount\":13,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/03\/Combo-box-in-excel-vba.png\",\"articleSection\":[\"Excel Macro Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/\",\"name\":\"Excel Macro Tutorial : ComboBox in Excel Macro - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/03\/Combo-box-in-excel-vba.png\",\"datePublished\":\"2012-03-25T08:46:00+00:00\",\"dateModified\":\"2022-08-07T00:25:29+00:00\",\"description\":\"Excel Macro Tutorial : How to Add Drop Down List in Excel? How to Add list Items in Combo Box? How to Remove Items from Drop Down? How to Select first Item as Default Value in Drop Down? How to remove All items from the Drop Down?\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/03\/Combo-box-in-excel-vba.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/03\/Combo-box-in-excel-vba.png\",\"width\":400,\"height\":250,\"caption\":\"Combo Box in Excel VBA\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro Tutorial\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-macro-for-beginners\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Macro Tutorial : ComboBox in Excel Macro\"}]},{\"@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 : ComboBox in Excel Macro - Let's excel in Excel","description":"Excel Macro Tutorial : How to Add Drop Down List in Excel? How to Add list Items in Combo Box? How to Remove Items from Drop Down? How to Select first Item as Default Value in Drop Down? How to remove All items from the Drop Down?","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\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/","og_locale":"en_US","og_type":"article","og_title":"Excel Macro Tutorial : ComboBox in Excel Macro","og_description":"Excel Macro Tutorial : How to Add Drop Down List in Excel? How to Add list Items in Combo Box? How to Remove Items from Drop Down? How to Select first Item as Default Value in Drop Down? How to remove All items from the Drop Down?","og_url":"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/","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":"2012-03-25T08:46:00+00:00","article_modified_time":"2022-08-07T00:25:29+00:00","og_image":[{"width":400,"height":250,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/03\/Combo-box-in-excel-vba.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":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Excel Macro Tutorial : ComboBox in Excel Macro","datePublished":"2012-03-25T08:46:00+00:00","dateModified":"2022-08-07T00:25:29+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/"},"wordCount":1123,"commentCount":13,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/03\/Combo-box-in-excel-vba.png","articleSection":["Excel Macro Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/","url":"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/","name":"Excel Macro Tutorial : ComboBox in Excel Macro - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/03\/Combo-box-in-excel-vba.png","datePublished":"2012-03-25T08:46:00+00:00","dateModified":"2022-08-07T00:25:29+00:00","description":"Excel Macro Tutorial : How to Add Drop Down List in Excel? How to Add list Items in Combo Box? How to Remove Items from Drop Down? How to Select first Item as Default Value in Drop Down? How to remove All items from the Drop Down?","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/03\/Combo-box-in-excel-vba.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/03\/Combo-box-in-excel-vba.png","width":400,"height":250,"caption":"Combo Box in Excel VBA"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2012\/03\/excel-macro-tutorial-combobox-in-excel-macro\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro Tutorial","item":"https:\/\/vmlogger.com\/excel\/excel-macro-for-beginners\/"},{"@type":"ListItem","position":3,"name":"Excel Macro Tutorial : ComboBox in Excel Macro"}]},{"@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\/12131"}],"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=12131"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12131\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/242544"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}