Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show todays date if ticked
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show todays date if ticked
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. -- Kevin Backmann "Andy" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show todays date if ticked
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 "Kevin B" wrote: 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. -- Kevin Backmann "Andy" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
todays date | Excel Discussion (Misc queries) | |||
Exel increment date problem wrt todays date. | Excel Worksheet Functions | |||
Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions |