Last month’s article, “ Pro tip: Add a UserForm to aid data entry in Excel,” shares the basics of creating an Excel UserForm using VBA to populate list controls.

As you can see in Figure H, Microsoft imports and formats the Excel data. To enter new data, click New and Microsoft Lists will open a data entry form.