Hi,
I apologize if this has been explained before but I haven't seen it on the Site.I'd appreciate if someone could give me an example of combining multiple search options. What I'd like to do is on a userform I ask user to define search criteria such as Temperature, pressure, flow and chemical name. I had only one search filter before and that was the chemical name but it's huge and now I need to filter out more sheets based on temp, press and flow. For these three I have text boxes.
The problem is the probability of finding what user enters is slim to none. For instance user may enter 56.6 for temperature so I need to define the search such as <100 ; 100<x<200 and >200.
Same thing applies to pressure as well.

This is what I had for name search:


Public sh As Worksheet
Public sh1 As Worksheet

Dim chname as string  ' chemical name
chname = TextBox1.Text
For Each sh In Worksheets
 If chname = sh.Range("B3").Value Then
 
      Set sh1 = sh
      ListBox1.AddItem (sh1.Name)  ' add the sheet on which it finds the chemical 
            
   End If
  
Next
If it was a constant number I guess it would be easier to search but how do I go to search for < or > values?

By the way Temperature will be on A1 pressure on A2 and flow on A3 of each sheet.

My logic says that first search for chemical name as I do above then look what user entered for temp check A1 if it is less than 100 then look A1 if A1 is less than 100 then it is true if not forget about the first sheet you find go to the second one look for T and P and look what user entered for T and P and so forth.

Thus the sheets found must match 4 different criteria.

I think I should be using nested for next and if then but I haven't seen any examples and basically I'm stuck.

Any help or lead would be greatly appreciated!!!