Now, let’s insert the data validation control. Using the simple demonstration sheet shown in Figure A, click B2. Feel free to use one of your own files if you like or choose another cell.

TL;DR Key Takeaways : Creating a multi-step data entry form in Excel improves data collection efficiency by combining Excel’s features with VBA and macros for interactivity.

For instance, using the name CDE567 is not allowed. You cant use space in your Excel functions. That said, you can use an underscore like average_count in your function.