Excel Combo Box?

[Rmcta]

Is there a way to set up an Excel Combo Box so that users can pick a value from a list?

 

[rmikesmith]

Rmcta,

Yes, a couple of ways.

1. Use Data Validation -- Select Data/Validation... from the menu then choose list from the "Allow:" dropdown. You can select a range of cells or type in your own entries, separated by commas. [Note: If you want to use a range of cells on a worksheet other than the one in which you are setting up data validation, you must create a named range then reference this in "Source" box]

2. Use an ActiveX ComboBox control -- From the Control Toolbox, select the ComboBox icon then click and drag on the worksheet to create the control. Right-click and select Properties to change any properties. This is where you would set the range (ListFillRange property); Set the Style property to fmStyleDropdownList; you might want to adjust the ListRows property which determines how many items appear at one time in the list.

Method 1. is probably easier to set up while Method 2. gives more flexibility/options.


HTH
Mike

 

[Rmcta]

Thank you very much for your kind reply.
I will try tomorrow to see if I can make it work.
Good night!