MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Check Boxes


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

Range("D12").Activate
If ActiveCell.Value = "" Then
ActiveCell.Value = "X"
Else
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 ??

Ivan

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

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


Ivan