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?

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?

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?

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?