How to Insert a Combo Box in Excel 2010. Combo boxes are a useful way of entering data into an Excel spreadsheet, combining the flexibility of a text field with the convenience of a list box.

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.

Tips If you want Excel to save your data frequently, enter a small number, such as "1" or "2," in the Minutes text box within the Excel Options window.

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