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.


--
RPIJG
------------------------------------------------------------------------
RPIJG's Profile: http://www.excelforum.com/member.php...fo&userid=9285
View this thread: http://www.excelforum.com/showthread...hreadid=483304