 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / December 2007Check if cell content changed
Hi, i´d like to know if there´s a way to, programatically or via a formula, check if the content of a cell changed, without using an auxiliar cell to compare. Tks. We need more info. The fact that the cell has something in it means that at some point it changed (since all cells in a workbook are blank to start with). Is this a file you send to someone else? Is it a shared workbook? At what point do you want to "freeze" the contents of the cells? Do you need to store the prior values?  SignatureHTH... Jim Thomlinson > Hi, > [quoted text clipped - 3 lines] > > Tks. I do execute a routine that brings some values from other workbook to mine. Those values will be available to be changed, but not necessarily they will be. I just want to make that check, so I can mark with an "U" of update. If there´s no changes, i´ll mark with "". > We need more info. The fact that the cell has something in it means that at > some point it changed (since all cells in a workbook are blank to start [quoted text clipped - 9 lines] > > > > Tks. Since I don't know where your values are that you want to capture in terms of changing this works on the entire sheet. Right click the sheet tab and select view code... Paste the following in the code window. Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ErrorHandler Application.EnableEvents = False Target.Offset(0, 1).Value = "U" ErrorHandler: Application.EnableEvents = True End Sub SignatureHTH... Jim Thomlinson > I do execute a routine that brings some values from other workbook to mine. > Those values will be available to be changed, but not necessarily they will [quoted text clipped - 14 lines] > > > > > > Tks. Ok... the event handler is a good idea. I´ll work on it. > Since I don't know where your values are that you want to capture in terms of > changing this works on the entire sheet. Right click the sheet tab and select [quoted text clipped - 26 lines] > > > > > > > > Tks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.