VBA Dependent Drop Down Menu and "Subscript out of range error"

Joined
Nov 29, 2011
Messages
1
Reaction score
0
Hi first off I'm new to VBA and its functionality... so please be nice :)! basically I have created sum ranges that hold my data for countries and locations (as in counties).. what I am aiming to do is have it such that when i choose england for instance i can only choose the english counties from my range... but am kind of clueless at how to do it at the moment.. also when i tried to set up an for-each statement to fill up my commandbox drop down i keep gettin "Subscript out of range" :confused:

any help would be GREATLY appreciated :thumb:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top