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.

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

How to Create a Form Using Microsoft Excel 2007. There are several ways to add forms in Microsoft Excel 2007, without the need to learn Visual Basic and type complex code.