The Ultimate Excel VBA Course - Learn and Master VBA Fast - InStr, InStrRev, and StrReverse

The video tutorial covers the use of the InStr function in VBA for searching strings, demonstrating its application with an email validation example. It also introduces the InStrRev function for reverse searching and the StrReverse function for reversing strings. Practical examples are provided to illustrate these concepts.

What does the in STR function return if the substring is not found?

• The length of the string

• The position of the last character

• Zero

• A negative number

In the email validation example, what does a location value of zero indicate?

• The email is empty

• The email contains multiple '@' symbols

• The email is invalid

• The email is valid

How does the in STR Rev function differ from the in STR function?

• It searches for numbers instead of strings

• It starts searching from the end of the string

• It returns a boolean value

• It only works with uppercase letters

What is the purpose of the STR reverse function?

• To convert a string to uppercase

• To replace characters in a string

• To find the length of a string

• To reverse the characters in a string

In the STR reverse example, what will be the output for the string 'text to be reversed'?

• disrevert EB TXET

• text to be reversed

• reversed to be text

• TXET EB disrevert