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
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
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