Checkboxes on forms

[Rmagic]

Hello

I have a user form

With a couple of option buttons and check boxe and command button

Is it poss to make the option buttons unload then selfs and fade out (Stop working) if the check box is seleted

eg
option 1= wood
option 2= metal

if checkbox is ticked the 2 above unload (both become false and not able to selet them unitl the checkbox is unticked )

hope makes sense

Thanks

[Leith Ross]

Hello Rmagic,

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Norman Jones]

Hi Rmagic,

Try:

Private Sub CheckBox1_Click()
Me.OptionButton1.Visible = Not Me.CheckBox1
Me.OptionButton2.Visible = Not Me.CheckBox1
End Sub

--

---
Regards,
Norman



"Rmagic" <[email protected]> wrote in
message news:[email protected]...
>
> Hello
>
> I have a user form
>
> With a couple of option buttons and check boxe and command button
>
> Is it poss to make the option buttons unload then selfs and fade out
> (Stop working) if the check box is seleted
>
> eg
> option 1= wood
> option 2= metal
>
> if checkbox is ticked the 2 above unload (both become false and not
> able to selet them unitl the checkbox is unticked )
>
> hope makes sense
>
> Thanks
>
>
> --
> Rmagic
> ------------------------------------------------------------------------
> Rmagic's Profile:
> http://www.excelforum.com/member.php...o&userid=28595
> View this thread: http://www.excelforum.com/showthread...hreadid=484511
>