Excel VBA StrReverse Function
The StrReverse function returns a String after reversing the given String.
Syntax
StrReverse (Expression)
Parameter
Expression (required) – This parameter represents the String that you want to reverse.
Return
This function returns a String after reversing the given String.
Example 1
Sub ReverseFunction_Example1() ' Reverse the String "HELLO VBA". Dim revStr As String revStr = StrReverse("HELLO VBA") ' The variable will return string "ABV OLLEH". ActiveCell.Value = revStr End Sub
Output
ABV OLLEH
Example 2
Sub ReverseFunction_Example2() ' Reverse the String "HELLO VBA". Dim revStr As String Dim str As String str = "MADAM" revStr = StrReverse(str) If str = revStr Then MsgBox (str + " is Palindrome") Else MsgBox (str + " is not Palindrome") End If End Sub
Output
MADAM is Palindrome