Add a Combo Box to a UserForm in Excel

This Excel VBA tutorial shows you how to add a ComboBox (Drop Down List or Menu) to a UserForm (User Form) in Excel. You will learn how to create the drop down list, how to edit the drop down list, and how to add, edit, and remove items from the drop down list. There are five different examples of how to add data to the ComboBox and thorough explanations with each example. Some examples show you how to create the ComboBox from data contained within a worksheet and other examples show you how to use data from VBA for the ComboBox. This tutorial covers everything that you need to know in order to add a ComboBox to a UserForm in Excel.