Real time data feeds don't appear to trigger worksheet change event.

Does anyone have any idea how I can trigger my macro when values fed in
to cells through DDE or RTD reach a threshold?

Thanks in advance

You can use OnData to specify a macro to run when the workbook is
updated via DDE.


Application.OnData = "MyMacro"



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"DTM" wrote in message
oups.com...
Real time data feeds don't appear to trigger worksheet change
event.

Does anyone have any idea how I can trigger my macro when
values fed in
to cells through DDE or RTD reach a threshold?

Thanks in advance

What about cheating by creating a function in another cell -
=mynewfunction(rtd cell reference, threshold)

and then write a custom function where the function has a line

if rtd cell reference.value threshold then
'do stuff here
else
'do nothing
end if

That will do the job...



--
www.alignment-systems.com


"DTM" wrote:

Real time data feeds don't appear to trigger worksheet change event.

Does anyone have any idea how I can trigger my macro when values fed in
to cells through DDE or RTD reach a threshold?

Thanks in advance