VBA Autofilter

[SamuelT]

Hi all,

I have a UserForm that I want my colleagues to enter a phrase and it will bring up anything in a column with the phrase/word in it - i.e. *whatever* - by applying the custom autofilter to a column.

I've built a form, etc, but can't work out the VBA I need to assign to the 'Find' button to apply the custom autofilter.

I currently have this attempt:

Private Sub cmdSearchForm1_Click()
 
Dim sData As String
   

   Selection.AutoFilter Field:=2, Criteria1:=sData

End Sub

...but it basically filters to NonBlanks.

Can anyone help?

TIA,

SamuelT