Combo box should trigger another combo box

**se7en_hills** · 10-19-2008, 12:51 PM

Hi ppl,

I have to create two combo boxes and when a user selects a value from one combo box, the values should get changed in the other combo box.

For example : if one combo box has values like "c/c++ programming" "java programming" and so on.. ... i would like to display the authors recommended (corresponding to combo box1) in the combo box 2.

please help me out!!!

thanks in advance..

**royUK** · 10-19-2008, 12:59 PM

What kind of comboboxes are you using.

Where is the list stored?

Attach an example workbook for easiness

**protonLeah** · 10-19-2008, 01:03 PM

The workbook attached was posted several months ago for a similar request. I lost the link so can't give due credit:
dependentdropdowns.xls

**se7en_hills** · 10-19-2008, 02:02 PM

Hi,
thts what i was asking for my work. but i can't understand one thing. how have they given the link for "Lower Case" which comes under "Alphabet" (in column B)and "LowerCase" (column F)...

what does INDIRECT(SUBSTITUTE(A3," ","")) DO EXACTLY??

since i'm new, i'm little slow to understand.

please reply...

**Leith Ross** · 10-19-2008, 03:49 PM

Hello se7en_hills,

The formula removes any spaces in the cell value. This is necessary because of the use of named ranges. A named range cannot contain spaces. It can contain an underscore in its place. So, a cell value like "Roman Numeral" is converted to "RomanNumeral" which matches the named range on "Lists" from I2:I20.

Sincerely,
Leith Ross

**se7en_hills** · 10-20-2008, 12:12 AM

Hi,

Thank u.. i got that..

can i make the user enter all the inputs in the form of drop down and when he clicks on the (say " Upload to Database ") button. The chosen inputs should be put into a query and upload it on the server.

Thanks....

**Leith Ross** · 10-20-2008, 01:44 AM

Hello se7en_hills,

Since your last question does not continue on with your original post, you should start a new thread. Title your new post appropriately to reflect your question.

Sincerely,
Leith Ross

**totem_pole** · 07-31-2015, 03:47 AM

Hi RoyUK

I have pretty much the same problem, I want a 2nd combo box to be populated with a named range depending on what option was selected in the 1st combo box. the combo boxes are in a userform not on the spreadsheet (not sure if that makes a difference as I have JUST started vba in excel). I tried looking at the example file you posted but it keeps making excel crash (hope that is not a virus).

PLEASE HELP!!!

totem

**totem_pole** · 07-31-2015, 03:52 AM

Originally Posted by protonLeah

The workbook attached was posted several months ago for a similar request. I lost the link so can't give due credit:
Attachment 29427

sorry wrong person......protonLeah please help

Hi RoyUK

I have pretty much the same problem, I want a 2nd combo box to be populated with a named range depending on what option was selected in the 1st combo box. the combo boxes are in a userform not on the spreadsheet (not sure if that makes a difference as I have JUST started vba in excel). I tried looking at the example file you posted but it keeps making excel crash (hope that is not a virus).

PLEASE HELP!!!

totem