Look at SetLinkOnData

you use this to assign a macro to run when the specific link changes.

See Chip Pearson page on Application.OnTime to see how to run a macro at a
specified time

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy


"ikantian" wrote in message
om...
I would like to have an excel event which temporarily (say, for 3
seconds) highlights/reformats a cell when the value in that cell
changes (from a DDE link) and then changes it back to its original
format.

Thanks much for any help.

But I have 100 different DDE links that change constantly. Am I
really supposed to have 100 separate SetLinkOnData statements for
each?
thanks.


"Tom Ogilvy" wrote in message ...
Look at SetLinkOnData

you use this to assign a macro to run when the specific link changes.

See Chip Pearson page on Application.OnTime to see how to run a macro at a
specified time

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy

You could have

Sub HandleA1()
Commonsub Range("A1")
End Sub

so it isn't quite as onerous as it appears, but in xl2000 or later, I
believe you can use the change event with DDE updates, so if that fits your
requirements, you can try that first.

Since the Change event passes the triggering cell, you wouldn't need 100
routines to handle the updates.

--
Regards,
Tom Ogilvy


"ikantian" wrote in message
om...
But I have 100 different DDE links that change constantly. Am I
really supposed to have 100 separate SetLinkOnData statements for
each?
thanks.


"Tom Ogilvy" wrote in message
...
Look at SetLinkOnData

you use this to assign a macro to run when the specific link changes.

See Chip Pearson page on Application.OnTime to see how to run a macro at
a
specified time

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy

the change event for XL on Office2000 definitely doesn't seem to work
with DDE updates. Unless i'm doing something wrong.
Not sure what HandleA1 code below means.
thanks.


"Tom Ogilvy" wrote in message ...
You could have

Sub HandleA1()
Commonsub Range("A1")
End Sub

so it isn't quite as onerous as it appears, but in xl2000 or later, I
believe you can use the change event with DDE updates, so if that fits your
requirements, you can try that first.

Since the Change event passes the triggering cell, you wouldn't need 100
routines to handle the updates.

--
Regards,
Tom Ogilvy


"ikantian" wrote in message
om...
But I have 100 different DDE links that change constantly. Am I
really supposed to have 100 separate SetLinkOnData statements for
each?
thanks.


"Tom Ogilvy" wrote in message
...
Look at SetLinkOnData

you use this to assign a macro to run when the specific link changes.

See Chip Pearson page on Application.OnTime to see how to run a macro at
a
specified time

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy