View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chasedan chasedan is offline
external usenet poster
 
Posts: 1
Default Can an Excel macro be automatically run based upon data in a cell?

I'm trying to poke a DDE message to RSLINX from Excel based upon whether a
cell in Excel contains the value 1 or 0. The value in the cell changes based
upon a DDE link to a timer running on an Allen Bradley PLC (Micrologix 1100).
I have a macro that can deliver the message but it must be initiated
manually. Is there a way to launch the macro automatically?