Thread
:
trigger an EVENT when the value in a cell changes?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Frank Kabel
external usenet poster
Posts: 3,885
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 With Quote
Frank Kabel
View Public Profile
Find all posts by Frank Kabel