Hi,

Is it possible to have the contents of a combobox list filterd depending on
the contents of a partcular cell.

e.g. Lets say I have a data range on sheet1 A1:G1000
combobox1 uses range sheet1 A1:1000 for it's list, this does not have does
not have unique records in the range and returns the selected value to cell
a1 on sheet2.

Q1. Can this be set to return unique values in the list?

I then want the contents of the list for combobox2 to use the range Sheet1
B1:1000 (which has unique record) but be filterd by the selection made in
combobox1. This will save users scroling through 1000 records to find the
item in the list in combobox2

Thanks
Pete