How can I have an if statement return a date that doesn't change (i.e. doesn't update like TODAY function)

Question

I am trying to set up a check in type spreadsheet where if a check box that we have received something is clicked, then today's date pops up in the cell next to it. But I want it to stay that date. I do not want it to change.

Plez,
Can I do that in excel. I am trying to build a check in type spreadsheet and am trying to use the control toolbar but can't find where I can define a click on event.

Answer 1

You set the onclick event of the button to return the current date via a VBA function.

It won't change if you set the date as a literal in your function.

Answer 2

If you use the check box event, then when it is checked the TODAY function writes the date to a new cell. When saved, that date should remain.

You don't want to test to see if the box is checked--you want to do something at the moment it is checked. So it won't update the date every time the sheet is opened--only every time the checkbox is changed from unchecked to checked.

Hope that helps

Answer 3

Not sure what you are trying to accomplish but sounds like you want to store the date in a global variable after you have retrieved it...

...So your using VBA. Just store the date the first time you retrieve it either in a global variable or a cell in the spreadsheet. Global if you need it for the life of the open spreadsheet, or cell if you need it permanently.

Answer 4

An if statement by definition doesn't return anything. It tests whether an expression is true or false, then acts upon that test. What are you trying to do?

Answer 5

What programming language or other software? What OS?

Answer 6

what particular programming language?