Prev: Trouble updating a cell's text that has a formula in it throug
Next: Insert Two Lines After Change in Project Number in Column A
From: porky2j on 16 Jul 2008 09:05
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
From: Susan on 16 Jul 2008 09:10
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, pork...(a)hotmail.com 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

From: porky2j on 16 Jul 2008 09:25
PERFECT!! Thank you soooooo much!

 | 
Pages: 1
Prev: Trouble updating a cell's text that has a formula in it throug
Next: Insert Two Lines After Change in Project Number in Column A