Posted to microsoft.public.excel.programming

Steph[_3_] Steph[_3_] is offline

external usenet poster

Posts: 312

Another change event question

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Quick VBA Worksheet Change Event or Selection Question:	Damil4real	Excel Worksheet Functions	6	November 17th 09 10:28 PM
Sheet change event and list validation question	Nick	Excel Programming	1	October 21st 04 01:20 PM
Change Cell from Validated List Not Firing Worksheet Change Event	[email protected]	Excel Programming	3	October 4th 04 03:00 AM
change event question	scott23	Excel Programming	3	May 13th 04 01:55 PM
change event/after update event??	scrabtree23[_2_]	Excel Programming	1	October 20th 03 07:09 PM

All times are GMT +1. The time now is 02:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us