Option Buttons and Drop Down List: Form Control

Hi Guys- I have two option buttons for the user to select either 'Canada' or 'US' and a drop down list in cell C7.

If the Canada option button is selected cell c2=1 if the US option button is selected cell C2=2.

If Canada option button is selected I need the cities in Q1:Q25 to appear in the drop down list (C7). If US option button is selected I need the cities in R1:R25 to appear in the drop down list (C7).

Any help would be much appreciated.

Thanks.

This dosen't really work when using radio/option buttons. I would use all drop downs but for some reson the boss wants option buttons. Thanks.

Do you currently have any code connected to the Option Buttons? Assuming not, I added this code to the buttons. Assuming your buttons are OptionButton1 and 2. I chose Cells (2,2) which is B2) because it is under my option button. Change this to fit your worksheet.

Please Login or Register  to view this content.

You can paste this code into the appropriate worksheet.

Then use VBA Noob's reference to create dependent dropdowns using Data Validation using INDIRECT(B2). See my example.

Questions?

ChemistB

Originally Posted by ChemistB

Do you currently have any code connected to the Option Buttons? Assuming not, I added this code to the buttons. Assuming your buttons are OptionButton1 and 2. I chose Cells (2,2) which is B2) because it is under my option button. Change this to fit your worksheet.

Please Login or Register  to view this content.

You can paste this code into the appropriate worksheet.

Then use VBA Noob's reference to create dependent dropdowns using Data Validation using INDIRECT(B2). See my example.

Questions?

ChemistB

This is PERFECT! Thanks Guys!