Hi,
I have some data in sheet 1 and I want to filter them using an userform.
column A: Name
column B: Num1
column C: Num2
in my user form I have a combobox to select Name, 2 textboxes to enter min and max for Num1, and 2 other textboxes to enter min and max for Num2.
after I Enter the data the following code will be run by clicking on Filter Button
But it doesn't work correctly
please help me
the combobox and textboxes can be empty.
if it is better to use Advanced filter, Please help me with that.
see the file
Bookmarks