View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Landon Landon is offline
external usenet poster
 
Posts: 12
Default Data Validation Using Radio Buttons

I have set up a series of 4 radio buttons using the control toolbox.
Depending on which of the 4 radio buttons the user selects, I would like to
display the following:

1) Drop down list 1
2) Drop down list 2
3) Drop down list 3
4) No drop down list, the adjacent cell is left empty for manual user input

I have the drop down lists created, but I can't get them to appear on the
form based on the radio button selection. I can set them up as one sorted
list if that is better (as described he
http://www.contextures.com/xlDataVal13.html )

I have not used VB for about 10 years, please help refresh my memory!

Thank you, -Landon