excel Macro Combobox

Hi, ive a this excel worksheet that contain data and another worksheet that has the user interface...now i would like to create a combobox that contains the list of data from the data worksheet and am wondering how to do that....pls help. Thanx

Highlight the data you would like in your combobox, then in the 'Name Box' (top left of your screen) type in a name for your list of data, for example 'list'.

Go to your input sheet, right click on your combo box and in Format control click on the control tab. In input range type =list and hey presto.

Hope that helped.

ive tried that but the problem is in the format control window there is no control tab...any other options?

The approach to use depends on which combobox you've used - is it the one from the control toolbox toolbar or the one from the forms toolbar?

I think the approach above works for the forms toolbar one. For the control toolbox one you need to right click, view properties and set the listFillRange property to your list as above

You could use the Excel Validation Option instead.
Instead of using a combo box, select a cell and go to Data > Validation.
Select Allow 'List' and set your source to be =list (or whatever you labelled your range as).
Is this acceptable?

ok..ive tried that and it works but unless the list is in the same sheet rite but in my case the list is in a different sheet, so how to do the fill range?

yoan write a piece of code to fill / refresh the list in the worksheet's activate event

do you need help with that?

btw, the items don't need to be on the same sheet on my excel... for either type of combo box

yup, i need help with that, hope u could show me how to do it

Maya,


This may work:

On the ListFillRange type

Sheet2!A1:A4

Sheet2! (Change Sheet2 to your worksheet's name followed by the exclamation mark... and change the A1:A4 to the cells range were your values are for the combobox)

Hope this help