Filtering a userform combobox based on another combobox

[terriertrip]

I've read several posts on this but I can't seem to find anything that fits exactly what I need. The closest I've come is on contextures http://www.contextures.com/exceluser...omboboxes.html but it doesn't quite produce the specific result because my first dependency does not repeat. I would also like to know if I can do this without using a hidden sheet, using only vba to filter the results using search find.

I have a sheet with a dynamically named range (State) that lists states (52). There is another dynamically named range (County) of all the counties within the U.S. (~4500). Each county has a named range code (CS_Code) that correlates to it's relative state (1-52). How would I go about creating an after click event within ComboBox1 (State) that would filter only the counties that belong to its respective state after it is selected within the ComboBox1?

I know I could separate all the counties into a 52 column range and use something like cascading comboboxes, but 1.) I'm more interested in finding out how I can use a unique id to filter out a respective county and 2.) I don't want to sort and parse out 4600 lines into 52 ranges. I'm afraid I don't have any code because I wouldn't know where to start but I have attached a sample workbook.

[nilem]

Hi Terriertrip,
try using a 2-columned Combobox1

[terriertrip]

Thank you, nilem. This is perfect.