View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rowan Drummond[_3_] Rowan Drummond[_3_] is offline
external usenet poster
 
Posts: 414
Default Quick and Easy from Checkboxes

Try:

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

Hope this helps
Rowan

RPIJG wrote:
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.