Checkboxes on forms

R

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
 
L

Leith Ross

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
 
N

Norman Jones

Hi Rmagic,

Try:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top