Checkboxes on forms
 

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

Checkboxes on forms
 

Hello Rmagic,


Code
-------------------

If CheckBox1.Value = True Then
OptionButton1.Value = False
OptionButton2.Value = False
OptionButton1.Enabled = False
OptionButton2.Enabled = False
Else
OptionButton1.Enabled = True
OptionButton2.Enabled = True
End If

-------------------


Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=48451

Checkboxes on forms
 

Hi Rmagic,

Try:

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

--

---
Regards,
Norman



"Rmagic" wrote in
message ...

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