RTD feeds into excel not trigering a worksheet change macro
Any help with this problem greatly appreciated, I am feeding live data
into cells and wrote a quick macro triggered to run when values in cell change Private Sub Worksheet_Change(ByVal Target As Range) However changes in data values in cells do not seem to cause following macro to run. Can anyone think of a solution? |
RTD feeds into excel not trigering a worksheet change macro
This macro must be in the module belonging to the worksheet you are
filling. Right-click on the tab of the worksheet and select <View Code. Now the VBA editor opens in the module belonging to this worksheet. If you insert your Worksheet_Change routine here it will work. DTM wrote: Any help with this problem greatly appreciated, I am feeding live data into cells and wrote a quick macro triggered to run when values in cell change Private Sub Worksheet_Change(ByVal Target As Range) However changes in data values in cells do not seem to cause following macro to run. Can anyone think of a solution? |
All times are GMT +1. The time now is 07:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com