Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! Searching for text with more than one criteria
you can use the AND function in the IF statement at the top to defin multiple instances of the INSTR(...) test (or the OR function etc..) i.e. If InStr(1, data, texttofind) AND InStr(1, data, texttofind2) Then ... ... ENDIF where texttofind2 is your second search criteria. if you want to seach for a string but don't know what you will b looking for when writing the code then a simple INPUT box statement ca receive you text without the need for a dialogbox with all th associated code: texttofind = INPUTBOX ("Enter Search Text" -- optionbase ----------------------------------------------------------------------- optionbase1's Profile: http://www.excelforum.com/member.php...fo&userid=2521 View this thread: http://www.excelforum.com/showthread.php?threadid=38799 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching for Data of a certain criteria | Excel Discussion (Misc queries) | |||
Formula for searching 3 criteria | Excel Discussion (Misc queries) | |||
Formula for searching 3 different Criteria | Excel Discussion (Misc queries) | |||
Searching for records with multiple criteria | Excel Worksheet Functions | |||
Searching two columns against a specific criteria | Excel Worksheet Functions |