SELECT CASE with INSTR is it possible???

[dwr0211]

I have code that checks for a string of data with in another string. I am new to Excel VB programming so I don't know if this is supposed to work or not. The string being checked does have the value of the search argument, however the Case does not happen. It is always going to the Case Else
Here is the code:

Please Login or Register  to view this content.

Thanks for your replies!

[BigBas]

Unless I'm misreading your code, I believe that you have a mistaken understanding of the SELECT CASE function.

SELECT CASE XXX treats XXX as the argument, and the CASE is treated as the validation. In this example, SELECT CASE strPathFile seems to be a text entry. In that syntax, each CASE argument checks if the result of your formula is strPathFile. However, (again, unless I'm misreading the code), each of the CASE formula arguments returns a TRUE/FALSE.

Try chaning the first line of the SELECT CASE to

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

See if that works. If not, post a sample workbook with dummy data (in xls format please)

[dwr0211]

The suggestion you made work fine. I changed the value in the main select to true and it worked fine. Thank you for your response!!