Except that "a" is Chr(97):
MsgBox Asc("a") , , Chr(97)
RBS
"joel" wrote in message
...
Each character has a ASCII code asociated with each character. The
lower case letters a-z start at character 96
Characternumber = asc("a") will equal 96
The letter b is 97 which is asc("a") + 1
The letter c is 98 which is asc("a") + 2
to convert a number back to the letter use the method Chr()
So MyLetterA = chr(96) which is lowercase "a".
the letter b equals chr(asc("a") + 1)
the letter c equals chr(asc("a") + 2)
the letter d equals chr(asc("a") + 3)
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=170229
Microsoft Office Help