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.

Now, let’s use this function to create a unique list. How to create a unique list in Excel Microsoft Excel supports two different dropdowns: Data Validation and a combo box control.

How to Make Colors Change With Validation in Excel. Excel's conditional formatting tool applies formatting depending on cells' contents. Validation rules can change cells font, style, size or border.