Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing a series of calculated values to analyse Real-Time Data
I want to be able to record cell changes over a random period of time in
order for me to attach events to specific patterns of cell changes. This has to be done in real time so that quick decisions can be made. How can this be done? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing a series of calculated values to analyse Real-Time Data
use the worksheet_change event to capture changes to cells.
http://www.cpearson.com/excel/events.htm for an overview of events. -- Regards, Tom Ogilvy "Gavin Marcus" wrote: I want to be able to record cell changes over a random period of time in order for me to attach events to specific patterns of cell changes. This has to be done in real time so that quick decisions can be made. How can this be done? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing a series of calculated values to analyse Real-Time D
Does this allow you to save multiple changes ie multiple calculations on
cells. What method is used to store the changes? "Tom Ogilvy" wrote: use the worksheet_change event to capture changes to cells. http://www.cpearson.com/excel/events.htm for an overview of events. -- Regards, Tom Ogilvy "Gavin Marcus" wrote: I want to be able to record cell changes over a random period of time in order for me to attach events to specific patterns of cell changes. This has to be done in real time so that quick decisions can be made. How can this be done? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing a series of calculated values to analyse Real-Time D
YOU write the code within the event that takes the calculated values and
stores them in a new location for further reference. No, it doesn't automatically do any work for you. For example Private Sub Worksheet_Change(ByVal Target As Range) if target.Address = "$A$1 then set rng = cells(rows.count,20).End(xlup)(2) Application.EnableEvents = False rng.Value = Range("a1").Value Application.EnableEvents = True end if End Sub is an example that would record changes made to cell A1. The history would be in column 20. -- Regards, Tom Ogilvy End Sub "Gavin Marcus" wrote: Does this allow you to save multiple changes ie multiple calculations on cells. What method is used to store the changes? "Tom Ogilvy" wrote: use the worksheet_change event to capture changes to cells. http://www.cpearson.com/excel/events.htm for an overview of events. -- Regards, Tom Ogilvy "Gavin Marcus" wrote: I want to be able to record cell changes over a random period of time in order for me to attach events to specific patterns of cell changes. This has to be done in real time so that quick decisions can be made. How can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capturing Real Time Data | Excel Worksheet Functions | |||
Capturing Trend Data over time | Excel Discussion (Misc queries) | |||
I need calculated time in a "real number" format | Excel Worksheet Functions | |||
VBA with real time data | Excel Programming |