Dear Forum,
I'm trying to get textbox1 to filter all columns from listbox1.
And, I'd like the listbox to refresh when I mistype (rollback)
I simply populate the listbox as shown below
Dim x As Long
x = Sheets("saneren").Cells(Rows.Count, 1).End(xlUp).row
With ListBox1
.ColumnCount = 6
.ColumnWidths = "100;0;0;0;0;0"
.ColumnHeads = False
.RowSource = "=saneren!A1:F" & x + 1
'.MultiSelect = fmMultiSelectMulti
End With
Based on this, how can I get the textbox to work for me as desired?
Regards, Ruud.
Bookmarks