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.

In a ListBox or ComboBox with a single column, use the AddItem method to add an individual entry to the list. In a multicolumn list box or combo box, you can use the List and Column properties to load ...

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

Show others who may be laboring with this how to get a value other than the displayed value from a combo box, listbox, etc. This is not the same as getting the index position in the list of values ...