| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping Text
How can you return the next letter in a sequence
Ie txt = a+ would equal b, then c then d etc.. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looping Text
Awesome! Thank you!
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.. . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looping Text
Awesome! Thank you! I just couldn't get the syntax!! Thanks!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looping input from a text box | Excel Programming | |||
| looping through text boxes | Excel Programming | |||
| Looping | Excel Programming | |||
| building a text string while looping though a worksheet | Excel Programming | |||
| Looping through Text boxes | Excel Programming | |||
Hybrid Mode
