How can I make a checkbox automatically be in a checked position if cell "J4" is greater than 100? I am also tring to use an activeX checkbox if that makes a difference.
Thanks in advance for the help
How can I make a checkbox automatically be in a checked position if cell "J4" is greater than 100? I am also tring to use an activeX checkbox if that makes a difference.
Thanks in advance for the help
Try this formula:
=IF(J4>100,CHAR(254),"")
Format the cell with the Symbol font
Therefore if J4>100 insert a marked checkbox else do not insert anything
If this answers the problem, click on the star below and change the title to [SOLVED]
Last edited by K m; 06-27-2012 at 05:13 PM.
Click on star (*) below if this helps
Instead on the Symbol font, the correct font is Wingdings
Hello
K m's formula inserts a symbol but if you want to check/uncheck an ActiveX check box then try the following code in the Worksheet Change event:
Here the Check Box name is 'CheckBox1'.Please Login or Register to view this content.
Hope this helps.
DBY
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks