LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default temporary cell format event

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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trigger Event on Format Change Zone[_3_] Excel Discussion (Misc queries) 4 August 25th 07 05:43 PM
Adjust cell values without a formula or temporary cell Ohpinion8ted Excel Discussion (Misc queries) 1 August 10th 07 03:00 PM
Temporary formatting of cell with focus Ricter Excel Discussion (Misc queries) 5 August 31st 06 12:47 AM
in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? Daniel Excel Worksheet Functions 1 June 23rd 05 07:53 PM
Make cell entry event change another cell? Ken[_11_] Excel Programming 2 August 7th 03 02:24 PM


All times are GMT +1. The time now is 11:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"