MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Check Boxes

Posted by Chris on October 13, 2000 9:59 AM

If ActiveCell.Value = "" Then
ActiveCell.Value = "X"
If ActiveCell.Value = "X" Then
ActiveCell.Value = ""
End If

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?

Posted by Ivan Moala on October 14, 2000 8:30 PM

Chris have you supplied all info ??
The routine worked for me (except you needed an
extra End if)
You mention a formula field ?? have you linked
the checkbox linked cell here ??


Posted by Chris on October 16, 2000 6:41 AM

The only way I have been able to attach a macro to a check box is by selecting the check box for modification and removing all information in the formula field. now could that be my problem is there something needed in the formula field or is it just Excel 2000 beening a pain in my ass?

Posted by Ivan Moala on October 17, 2000 2:52 AM

What you have explained should have worked ??
Poss to email me what you have ??