views:

364

answers:

4

Let's say I have this variable:

word = "habit"

which command in VBA will allow me to count how many characters are there in this variable (in my case it's 5).

Important: the variable "word" contains only one word, no spaces, but may have contain numbers and hyphens.

+3  A: 
Len(word)

Although that's not what your question title asks =)

David Hedlund
+3  A: 

Len is what you want.

word = "habit"  
length = Len(word)
Austin Salonen
+3  A: 

Use the Len function

length = Len(myString)
Robert Harvey
+4  A: 

Do you mean counting the number of characters in a string? That's very simple

Dim strWord As String
Dim lngNumberOfCharacters as Long

strWord = "habit"
lngNumberOfCharacters = Len(strWord)
Debug.Print lngNumberOfCharacters
Ben McCormack