Newbie: simple combo box

[Allie Tang]

Hello all,

I'm relatively new in Excel and having trouble with a comboBox. I
created the combo box by Control toolbox and placed in the same
worksheet with the data listed in a10:aa2087. Column A is model and
consists of 5 models [1,2,3,4,5]. I would like to built a comboBox
when we select 1, it retrieves all the data for model=1. As we select
2, it retrieves all the data for model=2... and so on. I've tried
playing with listFillRange, linkedCell, columnCount and boundColumn
and nothing seems to be working.

If you have any pointers, please let me know.

Thanks in advance.
Allie

 

[Dick Kusleika]

Allie

Is a10:aa2087 correct, or is that a typo? From where do you want to
retrieve them? Once you get them, what do you want to do with them? List
them in another combobox?