Combo Box Dependent Drop Down

[bemcbride]

I know the easiest way to do a dependent drop down is with Data Validation. However, the options in my lists are too long to use this (unfortunately, I cannot make them shorter.) I need to be able to create a 2 dependent drop downs (total 3 that cascade depending on the selection.)

I was thinking I could use a combo box and the cell link function. Then I could write a code that said "If this cell is equal to 1 then use this selection on the drop down. If this cell is equal to 2 then use this selection...etc.

Problem is I don't know if this would work and I'm not very good at writing code. There might even be a better way...

Any help is MASSIVELY appreciated, I've been trying to figure this out for ages.

 

[My Aswer Is This]

If I understand you correctly you would like to be able to choose from a list sort of like
Meats or Vegetables. And then you could choose Steak or Hamburger or chicken or if you chose Vegetable you would choose from a list of Carrots, Onions or Beets and then you could choose from a list of maybe Small, Medium, or Large. And the final result to go on your sheet would be for example.
Steak Medium or Onions Large
Is this similar to what you want?

 

[bemcbride]

Yes!

I don't even need a final result to come out. I just need to see the selections, it's on a form. So going with your example.

cell A1 would have a drop - Meats
cell A2 would have a drop - Steak
cell A3 would have a drop - Small

 

[My Aswer Is This]

You say "It's on a form". Do you mean Userform?
I don't think you can put a drop down list on a Userform.
I created a Userform with a Listbox that would show all the values in Column A1:A100 for example. And then another Listbox that would show all the values in say Column B1:B100
I was thinking that was what you wanted to do the choosing in a UserForm. Glad to help you if I can just understand what you would like.

 

[bemcbride]

No not in a user form. I meant that I am making a form.