Operation: The operator can obviously change any cell on the sheet, what I want to do is capture the value of the cell before the data is modified and the new just entered value.
Is there any simple way of doing this?
Accessing the Excel Undo stack perhaps?
Or does it take writing code coordinating the Worksheet_SelectionChange and Worksheet_Change events to capture the before data when the SelectionChanges in anticipation that it's going to be modified and identified in the Worksheet_Change event.
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.