| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change this code? | Excel Discussion (Misc queries) | |||
| VBA Code to Change the Tab Name | Excel Discussion (Misc queries) | |||
| VBA Code to Change the Tab Name | Excel Discussion (Misc queries) | |||
| Code to change references | Excel Programming | |||
| Change to Code | Excel Programming | |||
Hybrid Mode
