Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there a function to detect changes in any given cell? | Excel Worksheet Functions | |||
detect empty cell | Excel Programming | |||
How to detect if a cell is formula | Excel Programming | |||
Detect when Active Cell Changes | Excel Programming | |||
Need to detect cell shading | Excel Programming |