Excel change log vba

[lanser]

Hi I have a change log sup that faithfully records every change but I can't get it to save the old value. I have tried setting a variable in selection change event but nothing happens whe the change event calls the sub apart form completeing all the other values.
The original value cell (column D) remains blank

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[HaHoBe]

Hi lanser,

as you have made oval a module wide variable you coukd try and make it global like

Please Login or Register  to view this content.

if UpdateLog is located in a normal/standard module.

Ciao,
Holger

[WideBoyDixon]

Try this in the "ThisWorkbook" module instead:

Please Login or Register  to view this content.

WBD

[lanser]

Thanks Holger that worked and WBD I'll try yours too

John

[HaHoBe]

Hi John,

glad I could be of help here.

Holger