change log with VBA

[Mattlake]

Hi

I hope you can help me with a spreadsheet.

I have a spreadsheet with 3 tabs (AY21-22, AY22-23 and log[hidden]) that I need to track changes on.

I have found

Private Sub workbook_beforesave(ByVal SaveAsUI As Boolean, cancel As Boolean)

Dim wbLog As Worksheet
Dim iLastRow As Integer

Set wbLog = Sheets("log")
iLastRow = wbLog.Cells(wbLog.Rows.Count, "A").End(xlUp).Row + 1

wbLog.Cells(iLastRow, 1).Value = Environ("username")
wbLog.Cells(iLastRow, 2).Value = Now

End Sub

which works to log the user and when they access.

I want to also log which cells are altered even if it is just which cells are edited. Is this possible?

I have tried googling different ways to final a solution but unable to find anything (not even on youtube)

So it may not even be possible but if a VBA master can tell me that it isnt possible i would be soo happy and relieved.

Regards

Matthew

 

[Jeffrey Mahoney]

So... Its working for you?

 

[Jeffrey Mahoney]

In ten years, you'll be writing code and posting answers for others. if you think its a goal for you.

 

[Mattlake]

that worked perfectly

thank you again

 

[Hollywood22]

This site is here to learn. Ask as many questions as you need.
Put your cursor on Cell A1, then Using the Excel menu: Formulas > Name Manager > New > type in the name given and press enter

Hi there,

Was looking for something very similar to this (which is a great tool btw) curious about a couple applications:

1 - If this is in a table and I sort the table, will the change reference correctly rename itself to where it may now sit?
2 - Is there a method of also including the original value and updated value in the log?