This is probably so basic I'll shoot myself but I can't get this simple
command to work.

Basically,
I have an empty box that the user can type a string in.
I want to use the string to create an autofilter.
I have all the code to apply the filter, I just need to get the string from
the text box.

inpPNa is the text box and I've tried:
FilterVal = inpPNa.value, FilterVal = inpPNa.text
and both times: FilterVal = ""

I want to make this as easy as possible so I'd like to run the code whenever
someone types something in the box and presses Enter or Tab.

If I can get the string, I can add the wildcards to it as shown below.

Thanks,

MikeZz

Private Sub inpPro_Change()
Dim FilterVal As String

If Len(inpPNa) < 0 Then
FilterVal = "ClearThisFilter"
Else
FilterVal = "=*" & inpPNa.Text & "*"
End If