"counting" through the alphabet
 

I have a variable (DIM strLetter as string) that should change from A to X
(24 letters) using the same order as the alphabet.

Any suggestions to how I can set this up in my code? Functionality I'm
looking for:

DIM strLetter as string
For strLetter = A to X
Msgbox("strLetter is now: " & strLetter)
next strLetter

Thank you
The Doctor

"counting" through the alphabet
 

dim i&
for i = 65 to 77
strletter = chr$(i)
msgbox strletter
next




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Dr.Schwartz wrote :

I have a variable (DIM strLetter as string) that should change from A
to X (24 letters) using the same order as the alphabet.

Any suggestions to how I can set this up in my code? Functionality
I'm looking for:

DIM strLetter as string
For strLetter = A to X
Msgbox("strLetter is now: " & strLetter)
next strLetter

Thank you
The Doctor

"counting" through the alphabet
 

Sub CountChar()
Dim i As Long
For i = 1 To 24
MsgBox ("strLetter is now: " & Chr$(i + 64))
Next i
End Sub

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Dr.Schwartz" wrote in message
...
I have a variable (DIM strLetter as string) that should change from A to X
(24 letters) using the same order as the alphabet.

Any suggestions to how I can set this up in my code? Functionality I'm
looking for:

DIM strLetter as string
For strLetter = A to X
Msgbox("strLetter is now: " & strLetter)
next strLetter

Thank you
The Doctor