Show todays date if ticked

A

Andy

How can I set up a tick box in Excel to show todays date if ticked. I want to
be able to have a tick box indicating a product has been ordered then showing
the order date.
 
K

Kevin B

Click VIEW on the menu and select TOOLBARS and select the FORMS toolbar.

Click on the Checkbox and then click on the cell you want to place it in.

Double click on the check box and click the CONTROL tab and select the
default state for the check box, and in the CELL LINK field type an = and
enter the cell that will hold the value of the check box. Then enter a
formula that displays the current date if the CELL LINK field = TRUE or
nothing if the CELL LINK field = FALSE. See example information below.

In the example I have a check box over cell B4 and in cell D4 I have the
following formula:

=IF(B4=TRUE,TODAY(),"")

Substitute the cell addresses B4 and D4 to the cells you're using in your
worksheet.
 
A

Andy

Sorry mate but what is the formula for the CELL LINK.
I tried using your formula changing the cell addresses but not sure of the
formula for the tick box.
Using Office 2007
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top