Learn how to create a multi-step data entry form in Excel using VBA. Simplify data collection, reduce errors, and boost ...

Go to the ‘ Data ’ tab located on the Ribbon menu. Under the ‘ Data Tools ’ select ‘ Data Validation ’ option. When the Data Validation window opens, you’ll see several controls.

Figure A We’ll add a data validation control to this sheet. Click the Data tab, and then, click Data Validation in the Data Tools group. In the resulting dialog, choose List from the Allow dropdown.