Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trigger an EVENT when the value in a cell changes?
I am monitoring inputs from a PLC using OPC server software. I want a change
in state in an input to trigger an EVENT in Excel so I can activate a SubProcedure. I have tried an IF-then in a cell, using the monitored input to no avail. Public Sub OpDataEntry_Change(ByVal Target as Range) If Target.Address = ("BR12") Then '("BR12" is the IF..Then cell, which works.) (rest of code) End if End Sub Any suggestions? Regards, Glenn |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
trigger an EVENT when the value in a cell changes?
Hi
you need a supported event procedure. e.g. worksheet_change or worksheet_calculate. See: http://www.cpearson.com/excel/events.htm -- Regards Frank Kabel Frankfurt, Germany "Controls Freak" <Controls schrieb im Newsbeitrag ... I am monitoring inputs from a PLC using OPC server software. I want a change in state in an input to trigger an EVENT in Excel so I can activate a SubProcedure. I have tried an IF-then in a cell, using the monitored input to no avail. Public Sub OpDataEntry_Change(ByVal Target as Range) If Target.Address = ("BR12") Then '("BR12" is the IF..Then cell, which works.) (rest of code) End if End Sub Any suggestions? Regards, Glenn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trigger an event on Checkbox change | Excel Programming | |||
Trigger Event - Frank Stone | Excel Programming | |||
Trigger Event | Excel Programming |