It is very easy to get the Reverse of a string entered by user in Excel VBA by using VBA inbuilt functionality. strReverse() is the inbuilt function which returns reverse of the String given as input to this function.


strReverse("Your Input String")

Returned Value: It returns a reversed string of your given input String.

Example:Below code will return the Reverse of the String, entered in to A1 Cell in to B1 Cell, on clicking on the CommandButton1.

Private Sub CommandButton1_Click()
Range("B1").Value = StrReverse(Range("A1").Value)
End Sub


Join over 10, 000+ Excel VBA Enthusiasts & get this FREE e-Book Now!