Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for OptionButton displaying new frame
Hi all!
I have a user form with several frames containing optionbuttons. I want frame 4 to only be displayed if certain OptionButtons in Frame 1 are selected. If they are not selected I want Frame 4 to remain hidden. Is there a way to do this? Thanks in advance Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for OptionButton displaying new frame
in your userform_initialization code, make frame4.visible=false
then on each of the option buttons that you want it to become visible, use the click event: private sub opt1_click() frame4.visible=true end sub if you need to re-use the userform, make sure you call the initialization code again to reset it & make frame4 invisible once more. hope this helps susan On Jul 16, 9:05*am, wrote: Hi all! I have a user form with several frames containing optionbuttons. I want frame 4 to only be displayed if certain OptionButtons in Frame 1 are selected. If they are not selected I want Frame 4 to remain hidden. Is there a way to do this? Thanks in advance Paul |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for OptionButton displaying new frame
PERFECT!! Thank you soooooo much!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code to check OptionButton selected within multiple frames | Excel Programming | |||
Passing frame object in code | Excel Programming | |||
Use optionbutton value to select code to run. | Excel Programming | |||
Adding frame on multipage through code... | Excel Programming | |||
OptionButton in a Frame not visible | Excel Programming |