VB CODE RUN ON DDE VALUE CHANGE
 

Hi
you may have a look at the worksheet_calculate event or the OnTime
method. See the following sites:
http://www.cpearson.com/excel/ontime.htm
http://www.cpearson.com/excel/events.htm

--
Regards
Frank Kabel
Frankfurt, Germany


Alan wrote:
I'd like to run a VB routein when the number in a cell with values
from a DDE server are changed. The Worksheet.change command only
seems to work when I make the change from the keyboard. Is there a
way to run VB code every minute for instance? Thanks.

VB CODE RUN ON DDE VALUE CHANGE
 

Thank you the Timer function worked. Another question, I'd like to save this workbook with another name but I don't want the DDE link active in the file I'm saving to.
Alan