COMBOBOX
 

Ihave two combos and it has like 10 items .I am using control toobbox combo
and I want values to come in second combo as I select infirst combo. all
values are different for example If i select Green fruit in first combo then
In second lemon and lime comes and then when i select lime it takes me to
different worksheet which tells me the details of lime and so on.

See http://www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

"smiley" wrote in message
...
Ihave two combos and it has like 10 items .I am using control toobbox
combo
and I want values to come in second combo as I select infirst combo. all
values are different for example If i select Green fruit in first combo
then
In second lemon and lime comes and then when i select lime it takes me to
different worksheet which tells me the details of lime and so on.