Changed cell value not recognized

BDBatBear

Board Regular
Joined
May 4, 2005
Messages
56
WinXP - Excel 2003

I have the following sub-routine on a sheet to capture when a user changes the value in a range of cells:

Private Sub Worksheet_Change(ByVal Target As Range)
End Sub

For most users, the value of Target is the new value they have just entered into the cell. Thus, there is no problem.

However, for one of the users, the value of Target retains the value of the cell before the change is made. When I stop the debugger inside of this sub-routine and look at the worksheet, I do see the new version, but a debug.print of Target displays the old value.

Does anyone have any ideas about this?

Thanks,

- Bruce
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Joined
Jul 30, 2006
Messages
3,656
Can we see all the code between the following two lines?

Private Sub Worksheet_Change(ByVal Target As Range)
End Sub


Have a great day,
Stan
 

BDBatBear

Board Regular
Joined
May 4, 2005
Messages
56
The code is not relevant. I have a debug.print line and I manually print the values of Target (both value and address). The only difference is that the output in the problem computer is the initial cell value and on mine (and others) the new cell value.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,676
Messages
5,549,374
Members
410,911
Latest member
AniEx
Top