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

8 votes415 views1 answer
Vba make integer
VBA
0 vote333 views1 answer
Create new worksheet excel visual basic
VBA
0 vote530 views1 answer
Amd64 vs arm64 linux
VBA
1 vote359 views1 answer
Excel vba unload userform
VBA
0 vote353 views1 answer
Vbs write file
VBA
2 votes387 views2 answers
Excel vba if sunday or staurday
VBA
1 vote349 views1 answer
Excel vba make cell visible
VBA
0 vote380 views1 answer
Vba excel do not recalculate before save
VBA
0 vote352 views1 answer
Vb run command
VBA
0 vote373 views1 answer
How to get the value of optionbutton in vba
VBA