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.

Syntax:

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

cover3d_0-89071700_1484285537__1_

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