Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting pre edit values
I am using Worksheet_Change to identify edits on a sheet and highlight the
changes where appropriate by testing on the Target object. What I really need is to be able to retrieve the value of the cell before the edit is done, i.e. if the cell is changed from 2 to 3 I need to retieve the value 2. Is this possible?? Tnanks in advance for any help on this. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting pre edit values
In the change event,
store the current value of the changed cell Disable Events Application.Undo store the value of the changed cell (this is the 2 in your example) write the first value you stored enable events -- Regards, Tom Ogilvy "aps" wrote in message ... I am using Worksheet_Change to identify edits on a sheet and highlight the changes where appropriate by testing on the Target object. What I really need is to be able to retrieve the value of the cell before the edit is done, i.e. if the cell is changed from 2 to 3 I need to retieve the value 2. Is this possible?? Tnanks in advance for any help on this. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting pre edit values
Thanks Tom, neet solution works wonderfully. Would be good if 'pre edit
value' was an attribute on the Target object though. Next release maybe. "Tom Ogilvy" wrote: In the change event, store the current value of the changed cell Disable Events Application.Undo store the value of the changed cell (this is the 2 in your example) write the first value you stored enable events -- Regards, Tom Ogilvy "aps" wrote in message ... I am using Worksheet_Change to identify edits on a sheet and highlight the changes where appropriate by testing on the Target object. What I really need is to be able to retrieve the value of the cell before the edit is done, i.e. if the cell is changed from 2 to 3 I need to retieve the value 2. Is this possible?? Tnanks in advance for any help on this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003/edit/replace. Under Options/Look In, values is AWOL bu. | Excel Discussion (Misc queries) | |||
Why can't I edit my excel document? Edit buttons shaded. | New Users to Excel | |||
edit x-values in XY Scatter? | Charts and Charting in Excel | |||
Edit/Find/Options/Look In/Values | Excel Worksheet Functions | |||
Predict Y-values on new X-values based on other actual X and Y values? | Excel Programming |