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

Create a combo box called Colors on a form. Set the combo box's LimitToList property to Yes. To populate the combo box, set the combo box's RowSourceType property to Value List. Supply a list of ...

For instance, can you conditionally format the selected value in a combo box control? The answer is yes, but you won’t use conditional formatting; you’ll use a VBA procedure.

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