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

1 vote340 views1 answer
Excel vba first and last row and column in range
VBA
1 vote378 views1 answer
How to put a gridpain in a vbox
VBA
0 vote345 views1 answer
Compare dates vb
VBA
0 vote377 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote343 views1 answer
Excel vba range contains
VBA
0 vote376 views1 answer
Excel vba combine ranges
VBA
0 vote348 views1 answer
Vbscript check if string is empty
VBA
0 vote356 views1 answer
Excel vba calculate
VBA
0 vote357 views1 answer
Excel vba round to whole number
VBA
0 vote373 views1 answer
Excel vba first working day month
VBA