Posted by Chris on October 13, 2000 9:59 AM
If ActiveCell.Value = "" Then
ActiveCell.Value = "X"
If ActiveCell.Value = "X" Then
ActiveCell.Value = ""
This is a simple Macro I have attached to a check box, now when I clear the information in the formula field for that check box so I may attach a Macro to it I am unable to get that check box to work as a check box. Meaning when you typicly click on a Check Box and check mark show up in it. How can I change my code so that the check box will have a check mark in it when selected?