Combobox in Excel 2003

[Vagelisr]

Hi to all.

I have a combobox in a excell sheet.
It is possible to pass a parameter in the input range
instead of Parm!$B$1:$B$10

Thanks and regards.

[rryanp]

There are a couple options here. You can always send it a named range (so you name a range of cells and then put "=<name of range>" in the box). Or you may be able to use the INDIRECT function to reference a cell that has the range noted. I'm not sure on that last part, but I'd be happy to look into it if that's what you're asking. Can you give a little more detail about what you are trying to do?

[Vagelisr]

First of all thanks for your time.

I have attach a test.xls file.
As you see in the combo sheet when i select something from the first combo the second combo fills only with the "respectively" items
Example if i select Item1 in the first combo the second combo fills with Item11, Item12.......Item19

I want to pass a parameter to the second combobox to avoid fill it with empty entries.

Thanks.