Discussion Locked

Excel 97 Auto Update Cells

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way of indentifiing when the contents of a cell has been updated even when the contents show the same results as it has. For example, say cell A1 has a figure of 100. If a user enters the same figure later in the day, how can I say the cell has been updated with a new figure even when the same figure is entered.

5 replies

by roc180

Use the VBA event Worksheet_Change to track if a cell has been edited. This event fires after the Worksheet has been edited.

by atulkpatel

Could not find any reference to the VBA event "Worksheet_Change". Maybe looking in wrong place. Need better explaination please.

by roc180

I may have over simplified my answer. I guess a better place to start is to find out how familiar you are with VBA inside of Excel. If you can open the Visual Basic editor in Excel and check the help from within the editor for Change Event you will find documentation on what I was talking about. If you need further explination feel free to email me.

Neal Martinelli

by atulkpatel

Many apologies for not responding to your answer in the timely fashion as you did in answering to my question.

Thank you for you answer. It has helped me.

This discussion is closed to new replies.