» Create and Add a Function for Reversed Text Characters in Microsoft Excel
CATEGORY - Excel Importing Text Files , Custom Functions , Import and Export in VBA
VERSION - All Microsoft Excel Versions
- Click Alt+F11 to open Visual Basic Editor (VBE).
- From the Insert menu, select Module (to add a module).
- Enter the following lines of code into the module:
Function ReverseText(text) As String Dim TextLen As Integer Dim i As Integer TextLen = Len(text) For i = TextLen To 1 Step -1 ReverseText = ReverseText & Mid(text, i, 1) Next i End Function
Testing the function:
Book Store:
Recommended Books:
- How to Pay Zero Taxes (Annual)
- Microsoft Office XP Introductory Concepts and Techniques
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Microsoft Excel 2002 Simply Visual
- Absolute Beginner's Guide to Microsoft Excel 2002
- Microsoft PowerPoint Version 2002 Step by Step
No comments have been submitted.
