View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Detect Cell Changes

As long as you are not intending to use these sheets in HTML, you can use
the ID property of the cell like the .Tag property of some controls.
You could set the default value = to this then compare the .Value to the .ID
to see if you need to log the change or not.

With Target
If .Value < .ID Then
'Log it
Else
'clear log for that cell
End If
End With

However, these ID values are not stored with the workbook, so you would have
fill them will when you (re-)open the WB each time.
If this is from a template, you can loop through the cells in question,
setting .ID=.Value.

Otherwise it may be of limited use and it may be better to store the default
values elsewhere, possibly on a hidden sheet.

NickHK

"aga2957" wrote in
message ...

If possible, it shouldn't be log since it was changed to its original
state or value. But if not, it's would be fine.

Thank you so much!


--
aga2957
------------------------------------------------------------------------
aga2957's Profile:

http://www.excelforum.com/member.php...o&userid=25346
View this thread: http://www.excelforum.com/showthread...hreadid=573561