B
Bob Myles
How can you return the next letter in a sequence
Ie
txt = a+
would equal b, then c then d etc..
Ie
txt = a+
would equal b, then c then d etc..
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
maybe something like
txt=chr(asc(txt)+1)
maybe something like
txt=chr(asc(txt)+1)
G
Greg Wilson
Assuming the current letter is derived from the active
cell:
Sub NextLetter()
Dim txt As String
txt = ActiveCell.Text
txt = Chr(Asc(txt) + 1)
MsgBox txt
End Sub
Regards,
Greg
cell:
Sub NextLetter()
Dim txt As String
txt = ActiveCell.Text
txt = Chr(Asc(txt) + 1)
MsgBox txt
End Sub
Regards,
Greg
B
Bob Myles
Awesome! Thank you!
B
Bob Myles
Awesome! Thank you! I just couldn't get the syntax!! Thanks!