Category Archives for "Useful Procedures"

1 A function to reverse a string

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 StrReversePublic Function ReverseString(sInputString As String) As StringOn Error GoTo ReverseString_Error    ReverseString = StrReverse(sInputString)    Exit Function ReverseString_Error:    ReverseString = “#ERROR#”End Function

Continue reading
1 2 3