Dependent Dynamic Lists for Userform Comboboxs

Hi Everyone

I've been a member of this community for quite a while, and normally just by browsing through the threads I've often found solutions to my problems, But this time I couldn't so I'm writing to you excel gurus for some much needed help



I'm creating a userform with 2 dynamic, dependent Combobox's,

The Idea is that those 2 combobox's will display certain lists depending on what was selected in Combobox3(STATE)

The lists for the dependent comboboxes are contained in a separate worksheet (LISTS) in the same excel file

So if someone picks the State = QLD in Combobox3, it will bring up 1 dynamic list in Combobox2 and another in Combobox1, but if they selected State VIC in Combobox3, it will bring up 2 different Dynamic list in Combobox2 and Combobox1



written below is the code I have been trying to use, based on what I've seen elsewhere in this Forum and online, however it doesn't seem to work

If anyone can offer any advice it would be greatly appreciated

Please Login or Register  to view this content.

Thanks in Advance

Try this...

Please Login or Register  to view this content.

Hi Alphafrog

Thanks for your quick reply, however no luck Im afraid, I get the same error "Application-defined or object-defined error"

Could it be that my Dynamic Range definitions are wrong?

Just noticed a typo?

Select Case VomboBox3.Value

Hi AlphaFrog,

Yep I had noticed it, but it still doesn't work I'm afraid

Some of the L's in xlUp are 1s. They look almost the same.

Please Login or Register  to view this content.

Alpha Frog

You are an Excel GOD

Thank you very much

You're welcome.