Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting the occurrence of "Y" & "N" in Excel 2007 | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Can Excel "Autonumber" using the Alphabet? | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |