I'm using user forms to build a program and I want some radio button
hidden based on what the user selects on a previous form. I know yo
can set the radio button's visible property to false or true on th
form however I'm not sure how to change the visible property based o
what a user selects on a different form. For example my userForm1 ask
a user to select from different options in radio buttons, depending o
the selection UserForm1 sends the user to UserForm2, but also dependin
on the selection I only want certain options in radio buttons t
display so a user can only select further options that directly pertai
to the previous choices.

I know I could use different forms for each selection but I think thi
will make the program overly confusing and I would like to limit m
total user forms by hiding inappropriate choices based on the previou
choices.

Thanks for any help!

Micki

--
Message posted from http://www.ExcelForum.com