Dear All,
i stuck with the problem to build UserForm with textboxes.
Those textboxes should filter the data in the worksheet and filtrated data should populate the list box on the userform.
\1
that's the idea how it should look like.
I have following issues:
1. I have got the code to filter in the "Autofilter criteria 1", see picture
the code is basic:
it works well.Private Sub TextBox1_Change()
Dim numele$
numele$ = Me.TextBox1.Value
If numele2$ <> "" Then
Worksheets("Sheet1").Range("A3:BC500").AutoFilter _
field:=3, _
Criteria1:="*" & TextBox1.Text & "*", _
VisibleDropDown:=False
Else
Sheet1.AutoFilterMode = False
End If
but when i am trying in the textbox2 enter additional criteria i got an error (Syntax error).
i do not understand why.
without the userform the code works in the worksheet.
2. When i get filtrated data from textbox 1 the content on the listbox1 is not changed.
can you please let me know what i should to to populate the listbox1 with filtrated data?
thanks in advance for any comments form your side.
Bookmarks