combo box dropdown refer to another combo box

[koi]

hi,


if we have 3 domain names : fish, bird and fruit in combo box 1.


and we have sub type of fish, bird and fruit as sub domain in combo box 2.


can we make combo box 2 refer combo box 1?


example :


combo box 1 : we choose "fruit"

combo box 2 : only showing sub domain of fruit (it depend on combo box 1 entry)


i know this thing can be done if using name manager + data validation then Indirect formula..but i dont know how to do it using combo box


for presentation combo box is better than data validation since we can see the drop down arrow.

 

[Debraj]

Hi Koi,


In the Right-top of the page, try to search for "Dependent Drop down" or "Link Combo Box", you will find a huge range of same answer.

Still I would like to point some of them..


http://chandoo.org/forums/topic/linking-combo-boxes

http://chandoo.org/forums/topic/data-validation-list-automatically-shows-the-first-item-in-the-list


If you are facing any issue, please let us know.


Regards,

Deb

 

[SirJB7]

@Debra Roy

Hi!

I knew those links, the names sounded familiar to me...



Regards!