• Home
  • Blog
  • Resume
  • Contact
  • Projects
  • Gallery
  • Amit’s Resume
  • About Nagpur
KEEP IN TOUCH

A function to reverse a string

Aug16
2007
1 Comment Written by admin

Very simple, uses the VBA function StrReverse to reverse the input string.

‘A function to reverse a string provided as input
‘For example, the string “abcd” will become “dcba”
‘Uses the VBA function StrReverse
Public Function ReverseString(sInputString As String) As String
On Error GoTo ReverseString_Error
    
ReverseString = StrReverse(sInputString)
    Exit Function

ReverseString_Error:
    ReverseString = “#ERROR#”
End Function

Related posts:

  1. Range Concatenation with a character
  2. Concatenate function
  3. Excel Function to check if text is palindrome or not
  4. String Operations
  5. Stack Columns of Data on one column
Posted in String Operations, Useful Procedures - Tagged excel, UDF, VBA
SHARE THIS Twitter Facebook Delicious StumbleUpon E-mail
« Concatenate function
» Excel Books

1 Comment

  1. nkarthick's Gravatar nkarthick
    February 13, 2008 at 7:42 am | Permalink

    Hi
    Simple and superb code
    Please do visit my VBA blog
    http://chennaivba.blogspot.com
    and give me your thought.
    Thanks

Leave a Reply Cancel reply

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

*

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">

Tags

Access Alt F8 Books boxplot cells charts count cursor dashboard data mining dbase design error excel excel functions export filter flip LaTex MS query Number Err ODBC pipes Press Alt F11 Public Sub python R random numbers Range Cells report scripting software sparklines SQL SQL server stack columns statistics stemming string tag cloud text mining UDF VBA visualization wildcard

Network

View Ashutosh Nandeshwar's profile on LinkedIn

Recent Comments

  • larry on Access Export to Excel (2007)
  • Betty Chou on Projects
  • Rwill on Access Export to Excel (2007)
  • Bharathi on The search key was not found in any record in Access
  • Michael on The search key was not found in any record in Access

Related Posts

  1. Range Concatenation with a character
  2. Concatenate function
  3. Excel Function to check if text is palindrome or not
  4. String Operations
  5. Stack Columns of Data on one column

EvoLve theme by Blogatize  •  Powered by WordPress nandeshwar.info