View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] RJQMAN@gmail.com is offline
external usenet poster
 
Posts: 46
Default control the Visible Property on sections of a UserForm with a macro

I have userforms, each with 8 pairs of radio buttons (Yes-No
options). In many cases, the user will not need all eight sets -
perhaps only six of the eight apply, for example. Therefore I would
like to hide different pairs of the radio buttons, depending on input
from the user before the userform is loaded.

Each pair of buttons is inside of a frame, and the title for the
buttons is a text box that draws the title from other entries made by
the user.

Can I make the frame invisible and thereby everything inside of the
frame as well? That would be ideal, but I have no idea how to
structure a macro to change the property of the frame (or to change
the properties of the textbox and/or radio buttons).

For example, if I want to hide the two radio buttons and text box
inside of frame 7, depending on an integer that was selected in an
earlier part of the program, the concept would be;

If Integer1=1 then UserForm4, Frame 7 visible = false
If Integer1=2 then userform4.frame7.visible=true.

Is there a way to do this? Thanks for the assistance. I am lost here.