Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help on Excel 2003 Macro Visible Property | Excel Programming | |||
changing an activex control property using a macro | Excel Discussion (Misc queries) | |||
Programatically control picture property of Image control | Excel Programming | |||
How to show/hide sections of a userform? | Excel Programming | |||
Keep userform visible, but return control to calling routine | Excel Programming |