View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Shipley Chris Shipley is offline
external usenet poster
 
Posts: 5
Default Formula for tickbox?!?

Set the LinkedCell property of the checkbox to A1 or whatever cell it is to
be linked to.
If the cell value is True the checkbox will be checked, if False it will be
unchecked.
I believe 1 and 0 can be sunstituted for True and False respectively.
HTH
Chris

"Mario London" wrote in message
...


Is there a formula to add a tick in the tickbox if there is data
present in another cell? Does this sound confusing?


--
Mario London
------------------------------------------------------------------------
Mario London's Profile:

http://www.excelforum.com/member.php...o&userid=15726
View this thread: http://www.excelforum.com/showthread...hreadid=272468