Sorry Poltergeist, Your code only works for the first letter of the string.
Lo Siento Poltergeist, su codigó funcionamente solo para la primera letra del palabra.
The code below will work.
[tt]
Private Sub Command1_Click()
Dim strWord As String
Dim CurChar As String
Dim WordLoop As Integer
Dim TempCons As String
Dim TempVowel As String
'Change to your word or string reference
strWord = "Throughout"
For WordLoop = 1 To Len(strWord)
CurChar = Mid(strWord, WordLoop, 1)
Select Case UCase(CurChar)
Case "A", "E", "I", "O", "U"
TempVowel = TempVowel & CurChar
Case Else
TempCons = TempCons & CurChar
End Select
Next WordLoop
strWord = TempVowel & TempCons
MsgBox strWord
'or place strWord where you want
End Sub
[tt]
"I'm an idealist. I don't know where I'm going but I'm on the way." — Carl Sandburg, 20th-century American poet and writer