| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet Change Macro Help | Excel Discussion (Misc queries) | |||
| Feeds from one sheet to another | Excel Worksheet Functions | |||
| Cell value change to trigger macro (worksheet change event?) | Excel Programming | |||
| Sorting Data that feeds into other formulas.... | Excel Discussion (Misc queries) | |||
| Can Excel 2002 SP3 automatically import RSS data feeds? | Excel Discussion (Misc queries) | |||
![DTM[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
