The following userform contains one combo box, with an identifying label. You want to populate the combo box using the list in A1:A6 (on a sheet named LookupLists, which isn’t shown in the figure).

How to manage names under Excel? To define names in an Excel Workbook, you can either: For Excel 2007 or earlier version: Insert > Names > Define. Most current versions (from Excel 2010): Ribbon ...

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.