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

About this user

David Davis rsswire.info

« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS 

Detect a field edit in Excel and refresh a Query

   1  
   2  Private Sub Worksheet_Change(ByVal Target As Range)
   3      Dim wks As Worksheet
   4      Set wks = ActiveSheet
   5  
   6      If Target.Row = 1 And Target.Column = 1 Then
   7        wks.QueryTables(1).Refresh
   8      End If
   9  
  10      Set wks = Nothing
  11  End Sub
to vba query access excel worksheet by davetrane on Mar 01, 2007
« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS