Jemmeyson wrote:

I tried your VBA in a new blank worksheet and CELL A5 is not recording
the old value from A4 regardless of Saving and Closing the workbook.

Any further thoughts on this?

Make sure my code is in the ThisWorkbook object, not a module.

Also, is there a way to dynamically see the change as opposed to closing
and re-opening the sheet?

You could move the Workbook_BeforeClose code to Workbook_BeforeSave, but
you'd need to remove this line:

Me.Save

Then A5 will update every time you save.

--
The best sound in the world is the laughter of children.
Unless it's night and you live alone. Then it's the most terrifying sound.