Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

We can illustrate this technique by adding such a validation data control to the Membership Number column as follows: Select all existing data cells in the column in question.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.

The Data Validation feature in Excel 2013 offers a List option to confine selections in a cell to a preconfigured series of values. This selection can further influence the values in another list ...

The Data Validation window that pops up allows you to set your criteria in many ways. For our example, choose Whole Number for Allow:, greater than or equal to for Data:, and -700 for Minimum:.