Thread: Capturing a series of calculated values to analyse Real-Time Data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default 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?
Reply With QuoteReply With Quote