View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Andrews[_3_] Peter Andrews[_3_] is offline
external usenet poster
 
Posts: 1
Default Updating from Webpage

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.