Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.

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).