Pro tip: Populate an Excel UserForm ... download the example .xls or .xlsm file. Figure A Once you have your list entered, apply a name range: Now, you’re ready to add the UserForm: Press ...

The labels aren’t necessary on this simple example, but when creating a UserForm for your own data, you’ll probably want to include them. When you do, Excel’s default names are usually adequate.