This simple code reverses a string. (ie from 'hello' to 'olleh')
Function ReverseString(ByVal sText As String) As String
Dim lenText As Long, lPos As Long
If Len(sText) = 0 Then Exit Function
lenText = Len(sText)
ReverseString = Space(lenText)
For lPos = lenText To 1 Step -1
Mid$(ReverseString, lenText - lPos + 1, 1) = Mid$(sText, lPos, 1)
Next lPos
End Function
Comments