VBA StrReverse Function – Reverse Text

Last Updated on January 11, 2023 by token

1. StrReverse VBA Function – Description

The StrReverse VBA function   returns text with characters in reverse order. If we want to reverse characters in a text string starting from the last one, we should use this function.

2. VBA Replace function – Syntax

StrReverse (Expression As String) As String

Expression : The string in which we want to reverse the order of characters.

Function return : String / Value text value.

3. VBA StrReverse function – Example

How to use StrReverse  function  in VBA Excel? Below are examples of using the StrReverse function in the VisualBasic Editor.

Example 1 : An example of using the StrReverse VBA function – result in the MsgBox window.

Dim StrValue As String
StrValue = "Learning VBA functions"
MsgBox StrReverse (StrValue)
MsgBox StrReverse ("Datatalk.pl website")

Example 2 : VBA StrReverse – function example – result in an Excel sheet.

Dim StrValue2 As String
StrValue2 = "Learning VBA functions"
Range ("A1") = StrReverse (StrValue2)
Range ("A2") = StrReverse ("Datatalk.pl website")
Excel VBA Functions - StrReverse VBA function
Excel VBA Functions – StrReverse VBA function

4. VB StrReverse Feature – Additional information

  • lack

5. Function StrReverse VisualBasic – Where to use?

The function can be used in: Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365.

The article is part of the VBA Excel function list. You can find a list of all VBA functions at this address:  VBA functions .

Leave a comment

Your email address will not be published. Required fields are marked *

%d bloggers like this: