Tag Archives: Drop Down List

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

No Thumbnail

Excel VBA, Set Horizontal Alignment, (Sample Code)

In this article I will provide an example on how to set the horizontal alignment of cells using VBA. The user selects the horizontal alignment from a set of drop down lists. The selected horizontal alignment will be applied to the cell adjacent to the drop down list. You