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" 
any help would be GREATLY appreciated
! 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" any help would be GREATLY appreciated