| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Quick VBA Worksheet Change Event or Selection Question: | Excel Worksheet Functions | |||
| Sheet change event and list validation question | Excel Programming | |||
| Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
| change event question | Excel Programming | |||
| change event/after update event?? | Excel Programming | |||
![Rob van Gelder[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
