Looping Text
 

How can you return the next letter in a sequence

Ie

txt = a+
would equal b, then c then d etc..

Looping Text
 

Hi
maybe something like
txt=chr(asc(txt)+1)

--
Regards
Frank Kabel
Frankfurt, Germany


Bob Myles wrote:
How can you return the next letter in a sequence?

Ie:

txt = a+1
would equal b, then c then d etc..

Looping Text
 

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

-----Original Message-----
How can you return the next letter in a sequence?

Ie:

txt = a+1
would equal b, then c then d etc..
.

Looping Text
 

Awesome! Thank you!

Looping Text
 

Awesome! Thank you! I just couldn't get the syntax!! Thanks!