Is it a correct way to count the number of characters in a string

**kwfine** · 10-25-2011, 03:21 AM

Hi all,

I got a question when I was doing a very simple macro program.
I got three Strings as follows:

String1 = "ABC"
String2 = "你們好"
String3= "にっぽん"

Dim daysLengthString As String
Dim daysLength As Variant

daysLengthString = String1
daysLength = Len(daysLengthString)

MsgBox "The text " & daysLengthString1 & " is " & (daysLength) & " characters long"
MsgBox "The text " & daysLengthString2 & " is " & (daysLength) & " characters long"
MsgBox "The text " & daysLengthString3 & " is " & (daysLength) & " characters long"

Please give me some suggestion how to improve the program.

Thank you

Kitty.

**pike** · 10-25-2011, 03:25 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here