Archive of Mr Excel Message Board


Back to Controls in Excel archive index
Back to archive home

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?


Re: Check Boxes

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


Re: Check Boxes

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?


Re: Check Boxes

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


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.