Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Detect a field edit in Excel and refresh a Query (See related posts)

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim wks As Worksheet
    Set wks = ActiveSheet

    If Target.Row = 1 And Target.Column = 1 Then
      wks.QueryTables(1).Refresh
    End If

    Set wks = Nothing
End Sub
to vba query access excel worksheet by davetrane on Thu Mar 01 23:29:25 -0500 2007

You need to create an account or log in to post comments to this site.


Click here to browse all 4860 code snippets

Related Posts