Thread: combobox: control toobbox combo

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" <smiley@discussions.microsoft.com> wrote in message
news:FF8A349D-62A2-4637-8C25-7910EBDACC06@microsoft.com...
> 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.