Creating multiple dependent combo boxes

[jamiegfinch]

Hi. I have created a quiz to a foreign language and have multiple dependent drop down lists. i.e. whatever is selected in the 1st list affects what appears in the 2nd list. And whatever is selected in the 2nd list affects what appears in the 3rd list. However I have had problems adjusting the font size in the lists and someone recommended using combo boxes instead (which actually look a lot neater too). How would I go about doing the same thing but with combo boxes?
Also, one thing I forgot to mention, is that I have a command button that when pressed, selects a word at random in another spreadsheet. And at the moment when I click that button, whatever was selected in those drop down lists, resets back to default (nothing). I would like to keep that happening.

Hebrew Verb Generator - v2.xlsm

[humdingaling]

the two things you need to know with combobox

linked cell = where information of selected combo value is stored
listfillrange = your named list

so i hide the value of selected value of combobox behind the combobox itself

see attached

[jamiegfinch]

How did you get the words hiding behind the combo boxes synced with the boxes? Because I will need to move it all to cells B3:D3.

[humdingaling]

under developer tab, click on design mode

right click properties > linked cell

in case you dont know where to find developer tab
http://www.addintools.com/documents/...sign-mode.html

ps you dont have to have it behind the combobox if you dont want it
you can have it hidden anywhere on the sheet like in column H and hide it

[humdingaling]

D3, G3 and j3 on data 1 sheet have space at end of word which is making your named range not pick up properly

[jamiegfinch]

Yeh that fixed the problem for some of the lists not showing up. Thanks heaps. But the moment I move it all to cells B3:D3. Only the 1st combo box works. And the others aren't linked. I remember that before with the drop down lists, for the 2nd and 3rd drop down lists I had to do an Indirect function to the previous list. Where as these don't seem to be linked the same way.

[humdingaling]

there is some code you need to change in your main sheet
sorry since code exist for your command button i thought you knew to look there

as i also amended your command button to reset the combobox boxs
under command button

Please Login or Register  to view this content.

code for combobox (CBO)

1st triggers 2nd which triggers 3rd CBO

Please Login or Register  to view this content.

[jamiegfinch]

Good stuff! I knew something wasn't adding up properly and I'm not really savy with VBA code. Thanks heaps.

[humdingaling]

not a problem

glad to help

Cheers
Hum