Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Update Problem
I have a LARGE excel file with more than 100 active cells,
buttons, conditional formating etc. These cells receive information through RSLinx from various PLC modules in our facility. My Problem: a few of these cells need to be used as "triggers" When the value changes I want to open a msgbox alerting the user of a change on that sheet or another sheet not currently visible. Currently I can only get this to work if the cell value changes due to direct user input from the keyboard. If a formula updates say from 0 to 1 the cell "value" is still the formula typed into the cell, so the function: Private Sub Worksheet_Change(ByVal Target As Range) ' do something End Sub does not fire. Likewise the function: Private Sub Workbook_SheetCalculate(ByVal Sh As Object) ' do something End Sub does not fire. (These are built in excel functions I found in the help files.) Am I trying to to do something that is not possible, or just doing it wrong? If wrong, can someone show me how to do it right? Thanks in advance Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update a autofilter sheet from another sheet | Excel Discussion (Misc queries) | |||
Update Links problem | Excel Worksheet Functions | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
update links - problem | Links and Linking in Excel | |||
SolverOK Problem after SP-3 Update | Excel Programming |