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" <verysmallrox@yahoo.com> wrote in message
news:eqUfPuyAFHA.824@TK2MSFTNGP11.phx.gbl...
> 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?
>
>