You could use something like:
Code:
Sub Reverse()
Dim i As Long
Dim OldString As Variant
Dim RevText As Variant
OldString = Split(Selection.Text, " ")
For i = 0 To UBound(OldString)
RevText = OldString(i) & " " & RevText
Next
Selection.Text = RevText
End Sub