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

A common use of data validation is to create a drop-down list. Use it to restrict the type of data that users enter into an Excel cell.

Base a Data Validation dropdown on the Region values. Now, let’s use UNIQUE () to create a unique list of region values and then base a data validation dropdown on that list.

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.

How to Use SQL Statements in MS Excel. With most Excel spreadsheets, you enter data manually into cells and then use formulas or other functions to analyze it or perform calculations.