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

Populating a combo box isn't hard, but getting the combo box to communicate with a constantly changing list is a little more difficult. Learn how to populate your combo box with a dynamic list.

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

For example, assume that cells list employees' names and you want the user to choose a name from a pop-up combo box. VBA can run an event to open this box when the user selects the cell.