VBA checkbox code

[EMoe]

What is wrong with this code?

Private Sub Checkbox1_Click()
Userform1.Checkbox1.Value = True
Range ("A2").Value = True
Userform1.Checkbox1.Value = False
Range ("A2").Value = False


With this code if I check the check box I can see both true and falserun in the cell, then it ends up on false. And there is no check in the both - like it's cancelling itself out.

I want to check the box to return true in a call, uncheck to return false.

Help

[Leith Ross]

Hello EMoe,

The code is doing exactly what you told it to do. Set the the CheckBox True and then set the Checkbox False. What you want to do is If the checkbox is already True then have A2 equal True and vice versa. You need to test the current state of the CheckBox to return the proper value to A2.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[EMoe]

Thanks Leith,

I'll study my code & this one, then try it out.