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
Vbscript abs
VBA
1 vote305 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote295 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote266 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote285 views1 answer
Vba string
VBA
0 vote267 views1 answer
Excel vba automatic calculation
VBA
0 vote283 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
0 vote272 views1 answer
Vba remove numbers from string
VBA
0 vote267 views1 answer
Excel vba center userform
VBA
0 vote258 views1 answer
Vb test if reference is null
VBA