Can an Excel macro be automatically run based upon data in a cell?

C

chasedan

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?
 
C

Chip Pearson

I believe that if you provide a macro name to the OnData property
of the Application object, that macro will run when a DDE update
is made. E.g.,

Sub AAA()
Application.OnData "DoDDE"
End Sub

Sub DoDDE()
' do something
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
J

JakeyC

Take a look at the Worksheet_Change and _Calculate events in the VBA
editor, or press F1 and search for them in Help.

These may suffice for what you need to do.
 
J

JakeyC

Take a look at the Worksheet_Change and _Calculate events in the VBA
editor, or press F1 and search for them in Help.

These may suffice for what you need to do.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top