R
Raj
Hi,
A worksheet contains data as follows:
Column A ColumnnB
Country1 $B$24:$B$30
Country2 $B$9:$B$18
Country3 $B$42:$B$51
and so on
Column B has the range in another sheet where the list of States/
counties in the corresponding country are stored
When the user clicks in the corresponding cell in Column C,a dropdown
list should display the names in the range in column B and validate
that only one of those values is input.
How can this be achieved through VBA?
Thanks in advance for the Help.
Regards,
Raj
A worksheet contains data as follows:
Column A ColumnnB
Country1 $B$24:$B$30
Country2 $B$9:$B$18
Country3 $B$42:$B$51
and so on
Column B has the range in another sheet where the list of States/
counties in the corresponding country are stored
When the user clicks in the corresponding cell in Column C,a dropdown
list should display the names in the range in column B and validate
that only one of those values is input.
How can this be achieved through VBA?
Thanks in advance for the Help.
Regards,
Raj