| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i insert a tickbox in an Excel cell? | Excel Discussion (Misc queries) | |||
| How do I count a tickbox in a spreadsheet? | Excel Discussion (Misc queries) | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Hybrid Mode
