topic Alphabet wrangling. in VBA Forum

Alphabet wrangling.

Anonymous — Wed, 12 Oct 2005 11:37:10 GMT

Oh my gawd this question seems so simple I'm embarrassed asking it:

In VBA, is there a way you can increment a letter variable to be the next letter in the alphabet?

For example, if Myvar = "a", can I make Myvar = "b" without having to assign it directly?

I want to name a series of objects a letter starting at "a", with the next object called the next letter, and I don't know how many objects I'm going to have. With integers, obviously, you can just add 1, but can you do something similar with letters?

Re: Alphabet wrangling.

Anonymous — Wed, 12 Oct 2005 11:53:04 GMT

This should do it for you!

Joe
--

Public Function IncrementCharacter(Char As String) As String
IncrementCharacter = Chr(Asc(Char) + 1)
End Function

wrote in message news:4981907@discussion.autodesk.com...
Oh my gawd this question seems so simple I'm embarrassed asking it:

In VBA, is there a way you can increment a letter variable to be the next
letter in the alphabet?

For example, if Myvar = "a", can I make Myvar = "b" without having to assign
it directly?

I want to name a series of objects a letter starting at "a", with the next
object called the next letter, and I don't know how many objects I'm going
to have. With integers, obviously, you can just add 1, but can you do
something similar with letters?

Re: Alphabet wrangling.

Anonymous — Wed, 12 Oct 2005 12:01:12 GMT

Thanks Joe, you're a life saver. That's exactly what I needed!