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

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

Populating a userform combo box with a static list takes a little knowledge and some VBA code. Getting the combo box to update when the list updates requires a bit more work.

Add a Unique List of Values to a Combo Box These examples show different approaches for taking a list from a spreadsheet and using it to populate a combo box control using only the unique values. The ...

Note This example adds an item to an unbound combo box. When you add an item to a bound combo box, you add a value to a field in the underlying data source. In most cases you cannot simply add one ...