Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2007 (Home Edition)
I'm obtaining data from a webpage, however the following works when I manually update cell B3, but doesn't when the cell is updated automatically by the "Get external data from web" function. Does the "Get external data from web" function inhibit the Worksheet_Change facility? ...and, if so, how do I make it work. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$b$3" Then MsgBox "Hello World" End If End Sub Many Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA in a webpage | Excel Programming | |||
Publishing Webpage? | Excel Discussion (Misc queries) | |||
Updating an excel chart on a webpage | Charts and Charting in Excel | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions | |||
rondebruin's webpage | Excel Discussion (Misc queries) |