This lessons looks at using Excel VBA to create a History Log on a separate sheet of changes that happen on another sheet. This log will include the the following:
1. The cell address that gets changed
2. The previous value of the cell
3. The new value of the cell
4. The user who made the change
5. A date and time stamp of when the change was made
Learn More about Excel VBA & Macros with this Book on Amazon:
amzn.to/3xnqT6R
Get a Microsoft Office 365 Personal Subscription with this Amazon link:
amzn.to/3aV9GtL
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.
#ExcelVBATrackChangeHistory
#ExcelVBADateAndTimeStamp
#ExcelVBALogChangeHistoryOnSheet