prasadksu
05-04-2011, 11:03 PM
Is it possible to do a State/County combo box scenario in an user form. I mean creating a "State" combo box in one column with all the states in the U.S. and a "County" combo box in the adjacent column. Is it possible to configure the two combo boxes so that if you choose NC for example in the State combo
box, the only choices available in the County combo box are NC counties. Once selected the data should enter into a cell in excel sheet.
I am new to VBA and any example of doing it would be greatly appreciated.
Thanks,
Prasad.
box, the only choices available in the County combo box are NC counties. Once selected the data should enter into a cell in excel sheet.
I am new to VBA and any example of doing it would be greatly appreciated.
Thanks,
Prasad.