Thread: Another change event question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
  
Posts: 1,236
Default Another change event question
There is no event for BeforeChange, unfortunately.

You must store the value separately as the cell changes so you can refer to
the value at next change.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Steph" wrote in message
...
Can I somehow capture what the cell value was before it was changed?

I know I can capture the cell changed and the changed value in the
following:
MsgBox "You changed: " & Target.Address & " to " & Target.Value

I would love it to tell me You changed A1 from 15 to 25

Possible?




Reply With QuoteReply With Quote