Is there anyway to tell how many letters are in a string? More
specifically, I have a userform where the user enters a string into a
textbox. The textbox will only accept a total of 10 letters. When the
string variable gets passed to my sub routine, I need to know how many
letters are in that string.

If I can determine how many letters are in the string, if there are
less than 10, I then want to add spaces to the end of that string to
make it 10 characters long.

For example, if I enter:
"August" (6 characters) - it will then change it to "August____" (_ =
" ")
"California" (10 characters) - it will not add any spaces


TIA for any help,

DejaVu


--
DejaVu
------------------------------------------------------------------------
DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629
View this thread: http://www.excelforum.com/showthread...hreadid=393382