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 vote121 views1 answer
Excel vba show developer tab
VBA
0 vote125 views1 answer
Find database connection string vb
VBA
0 vote127 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote107 views1 answer
Excel vba open browser
VBA
0 vote126 views1 answer
Excel vba set cell value to empty
VBA
1 vote121 views1 answer
Add a index column power bi
VBA
5 votes124 views1 answer
Excel vba right word from Long Integer
VBA
8 votes161 views1 answer
Vba make a short integer from two bytes
VBA
0 vote123 views1 answer
Nested if else in vb.net
VBA
0 vote121 views1 answer
Vbnet check if string is only numbers
VBA