VBA Excel adding dynamic validation list to multiple cells

I have created two drop down list of country and city which are dependent using this:

https://siddharthrout.wordpress.com/...ent-lists-vba/

However, now the issue is that I would like to create similar drop-downs below it using the same code in the file.

So I replaced Range("B2") with Range("B2:B11") and Range("C2") with Range("C2:C11") everywhere in the code.

But this is now giving the error 'Type Mismatch' and therefore not generating the required output. I am not good in vba so I am not able to understand what else should I change. Any help is greatly appreciated!

Also, for country Australia in cell B2 in sheet 1, it is showing Sydney and NSW separately which I want to be together.

Thanks in advance!

This is one of my favorite techniques for cascading drop-down lists. Check it out to see if it will work for you.
http://www.utteraccess.com/wiki/inde...ists_%28VBA%29

Hi Lokesh3_14

Welcome to the Forum!!!

I didn't rewrite your existing Code, merely modified it. As dflak noted, there are other ways to do this...some better than others. Modified Code..

Please Login or Register  to view this content.

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.