Private Sub Command1_Click()
On Error Resume Next
Dim s As String
s = "123456789"
ss = ""
For i = 1 To Len(s) Step 2
ss = ss & Mid(s, i + 1, 1) & Mid(s, i, 1)
Next
MsgBox ss
End Sub
Private Sub Command1_Click()
On Error Resume Next
Dim s As String
s = "123456789"
Dim s1 As String
s1 = s
Dim i As Long, j As Long
For i = 1 To Len(s) Step 2
j = i + 1
Mid(s, j, 1) = Mid(s1, i, 1)
Mid(s, i, 1) = Mid(s1, j, 1)
Next
MsgBox s
End Sub