You can't do that with justa chckbox. Once run the code will not recognise when a number is entered. Why not use a WorkSheet event instead of the checkboxes.
You can't do that with justa chckbox. Once run the code will not recognise when a number is entered. Why not use a WorkSheet event instead of the checkboxes.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks for the tip Roy.
I considered trying to code it that way but I couldn't figure out how to only colour the cell when the checkbox is ticked from a WorkSheet event. It would be pretty straightforward to colour the cell depending on whether any text was entered using conditional formatting outside of VBA, but I guess it brings me back to my original question - how do I get the cell to change colours only when the checkbox is ticked?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks