Insert time on change in value within row - 2003

[jw400]

Hi all,
Im searching for a script to help me insert the current time value when a value within the row is changed. For example, if a value changes within the specified row, i.e. B1 changes, then within B12, the current date is inserted. However if B1 does not change then the old B12 value (old last change date) stays the same.

Im relatively new to VB and macro so any help would be appreciated!
Many thanks!

 

[jw400]

Hi guys, is anyone able to recommend a change to the code?
Thanks!

 

[jw400]

Bump! thanks!