Recording Cell Changes 1

[campbemr]

I am trying to create a macro that will record the changes that are being made to any cells within columns c,d,and e. From looking at previous posts I see that the worksheet_change event will be used to recognize the change in the sheet. But I have not been able to find any posts that help in being able to transfer the cell number, previous value, and the value that it has been changed to. I want to just start listing these changes on another worksheet. How can this be done?

 

[xlbo]

Dunno about previous value but for the rest try summat like this:

worksheet_change event

select case target.column
case is "C","D","E"
tStr = target.text
tAdd = target.address
tDate = format(now(),"dd/mm/yy hh:mm&quot
with sheets("Changes&quot
lRow = .range("A65536&quot.end(xlup).row
.range("A" & lRow+1).formula = tAdd
.range("B" & lRow+1).formula = tStr
.range("C" & lRow+1).formula = tDate
end with
case else
end select
end sub

HTH Rgds
~Geoff~

 

[campbemr]

Thanks for the help. The code worked great.
I had to change the line
case is "C","D","E" to
case 3 to 5
to get it to work. I don't know why. I'm just throwing that out there for anyone who tries to use this in the future and has problems.
Thanks