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
0 Comments