Hi Guys,

I am trying to filter worksheet with textbox value in userform but i am unable to do that. it is working if the values are text items but i want to filter with numbers. i have tried to change textbox format to number but no use. i am using below code to filter values now.

My textbox name is txtsearch.

With ActiveSheet

.AutoFilterMode = False

.Range("G1").AutoFilter Field:=7, Criteria1:=Me.txtsearch.Text & "*"

End With

Kindly suggest me to get it resolved.

Thank you all