Change reference to value upon save / state change

Hi,

you would need a VBA macro to achieve that. Possible approach

Hit alt-F11 to open the VBA editor and double click on ThisWorkbook in the navigation pane. Then copy this code into the code window

Please Login or Register  to view this content.

Change "Sheet1" to whatever your sheet name is.

Now, before the workbook is saved, B4 will be copied and pasted as values only.

hth

I would just add that it's probably worth validating the value first just to be sure it's a date (and a formula if nec.), something like:

Please Login or Register  to view this content.

you could use formulae but it would need to be circular by nature and would therefore require Iteration be enabled - avoid if possible.

if you turn on iteration tools/option/calculation check iteration
you can use in b4
=IF(X10=1,IF(OR(B4="input name first",B4=""),NOW(),B4),IF(X10=0,"input name first",""))
then so long as x10 has 1 in it will hold the date
hee hee

you could use formulae but it would need to be circular by nature and would therefore require Iteration be enabled - avoid if possible.

i just knew that was coming!