View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default VB CODE RUN ON DDE VALUE CHANGE

Look at SetLinkOnData

--
Regards,
Tom Ogilvy

"Alan" wrote in message
...
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.