Combo Boxes

[frizzy]

How do I add values to a combo box?

 

[TommyGun]

A combo box on a UserForm, or a combo box added to a worksheet using the Forms toolbar?

 

[frizzy]

I was thinking more along the lines of adding one to a worksheet using the Forms Toolbar, but if you have the answers for both that would be great.

 

[TommyGun]

Well, if you make a list of the values you want to appear in your combo box, and enter this list somewhere in your workbook, then add the combobox, goto it's properties, and set the input range equal to the list you created, then that should work.

 

[frizzy]

Yeah, that's what I tried to do - but when I right click on the combo box and select properties, I don't have an option for input range - is there something I'm missing?

 

[TommyGun]

Are you sure you inserted a combobox?

 

[frizzy]

Yes, I just added one from the Control Toolbox..............

 

[TommyGun]

Okay, that is for adding MSForms controls. This would require underlying VB code to run.

If you want to add a combobox to a worksheet, please use the "Forms" toolbar.

 

[frizzy]

Gotcha - thought I was going nuts there.....tks