View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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.