Quick and Easy from Checkboxes

  • Thread starter Thread starter RPIJG
  • Start date Start date
R

RPIJG

So I'm having an issue with Checkbox values...

I just want my code to do this...

If Checkbox1 is checked then run this code End if

If Checkbox1 is unchecked then run this code End if

Somehow or another it just doesn't seem to be working for me, I tried

If Checkbox1.Checked=True Then
'Code
End If
If Checkbox1.Checked=False Then
'Code
End If

For some reason, it didn't agree with me, it gave me a Compile Error
and said Method or Data Member not found. I give up. Checkbox is in a
userform by the way, not sure if that makes a difference or not.
 
Try:

If CheckBox1.Value = True Then
MsgBox "checked"
Else
MsgBox "not Checked"
End If

Hope this helps
Rowan
 
Thanks that worked like a charm, for some reason the VB help inde
showed it as Checked instead of Value, replacing fixed the proble
right up
 
You're welcome.

PS you may have been looking at help for the checkboxes collection
rather than the Checkbox Control.
 
Back
Top