Category Archives: Drop Down Lists

No Thumbnail

Drop Down List Creator (Sample Code and Download)

The following code is a function I’ve written which creates drop down lists. The drop down lists are created using data validation. It is assumed that there is a column with the drop down list values on one of the sheets. Another feature of this

No Thumbnail

VBA UserForm Drop Down Lists

In this article I will explain the userform drop down list. This drop down list is actually called a combo box. It is used in user forms. Jump To: Creating Adding Items Inserting Items Modifying Items Removing Items Get Selected Index Get Selected Item Item

No Thumbnail

Excel Drop Down Lists

Generally speaking there are 3 types of drop down lists in Excel: Form Control ActiveX Data Validation. In this article I will brieftly explain each one and provide links to more detailed explanation of each. – Form Control (Combo Box): These drop down lists which are