I have found the Worksheet_Change function to be a great way to provide
criteria in Excel and return data from SQL tables. For example, typing a
city would return all of the address records for that city. Typing a
different city would clear and return a new record set.

The problem that I am having is that the Worksheet_Change function works
great on my machine and I am able to supply criteria in the target area over
and over and get different data each time. It doesn't, however, repeatedly
work on other machines. When sending the spreadsheet to other folks, the
first entry will result in retrieved data but changing the value in the
spread won't update the data.

I simplied the code down to a simple message box:

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Application.Intersect(Target, Me.Range("Search")) Is Nothing Then
MsgBox Application.Intersect(Target, Me.Range("Search"))
End If

End Sub

Whatever is typed in the target is echoed in a message box. My machine
works fine, other only once.

Any ideas on where I should look for differences would be appreciated.