Vba string length

MsgBox Len("Helloworld !")     ' 12

Vba string length

Dim myString as String
Dim arr() as String
Dim str_len as Integer

myString = "Come visit Mzansi over the holidays"
arr = Split(myString, " ")
'Compute string length i.e number of 'words'
str_len = UBound(arr) - LBound(arr) + 1

Similar codes

0 vote264 views1 answer
Find database connection string vb
VBA
2 votes223 views1 answer
Vba uppercase first letter of each word
VBA
5 votes271 views1 answer
Excel vba how to unit test vba code
VBA
0 vote238 views1 answer
Excel vba hide columns
VBA
0 vote230 views1 answer
Vb check if row has column
VBA
0 vote219 views1 answer
Vba file size
VBA
5 votes262 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote235 views1 answer
Vba shape transparent
VBA
31 votes538 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote245 views1 answer
Vbnet convert charatcer to binary
VBA