Checkbox to date stamp cell when checked

[jsherwood]

I'm having an issue with trying to implement a date stamp when putting in a check in one of my inserted boxes. It doe popluate the date and time but wants to update: date and time when I open the excel file?? The formula I am using is below.

Please Login or Register  to view this content.

[¯\_(ツ)_/¯]

NOW() is a volatile function, so it recalculates whenever a sheet change occurs, or a calculation event, and if your workbook is set to auto-calc, it does so upon opening.

To make the cell a date/time stamp, you would need to set it to manual calculation, or link the checkbox to a macro that will set a static date/time value in the cell.

[¯\_(ツ)_/¯]

Example of macro linked to a Forms control checkbox. (Right-click your checkbox > Assign Macro > New > paste code and adjust any checkbox names and cell references to work in your actual workbook.)

Please Login or Register  to view this content.

[jason.b75]

Or use a circular reference.

=IF(J5,IF(N(K5),K5,NOW()),"")

Change the references to K5 to the cell that the formula is going into. Remember to enable iterative calculation and set the checkbox linked to J5 to off before entering the formula.

[jsherwood]

Awesome! Appreciate the help. I ended up using the iteration method