If condition not working with InStrRev

Hi,

I'm trying to check if the string has a backslash at the end. However my if condition which checks if the slash is present is not working properly. My code immediately skips to the second msgbox...any help would be great.

Please Login or Register  to view this content.

Thanks,
amphi

There is not slash in mystring so it skips.

Sorry guys had a brain freeze. Thanks the instr() is perfectly ok for this.

Originally Posted by cytop

Why would you use InStrRev for this? The basic InStr() function would give the same result.

Actually InStrRev is better now because InStr will return wrong result for mystring = "Hi I'm \ a string"
But for that it would need aditional check that InStrRev result is same as Len(mystring)

Or just this:

Please Login or Register  to view this content.

If you are "...trying to check if the string has a backslash at the end" (post #1) then

Please Login or Register  to view this content.

or some variation thereof.

You could also get rid of a couple of lines of code

Please Login or Register  to view this content.

(Essentially the same as the previous post).

None is 'more right' than the other - the primary concern is readability.