Data Validation in Microsoft Excel allows users to control the type of data entered into the worksheet. It picks from a list of rules to limit the type of data that can be entered into a cell.

In this case, that’s B3:B6. Click the Data tab, and choose Data Validation from the Data Validation dropdown (in the Data Tools group). In the resulting dialog, choose Custom from the Allow drop ...

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