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 vote207 views1 answer
Vbnet add new ecel sheet
VBA
0 vote225 views1 answer
Loop through all text boxes in a form vb
VBA
31 votes515 views1 answer
Vba how to convert a column number into an Excel column
VBA
2 votes161 views2 answers
Vba exit loop
VBA
1 vote221 views1 answer
Add control vb
VBA
0 vote179 views1 answer
Vba code to remove leading and trailing spaces
VBA
25 votes549 views3 answers
String to date vb
VBA
0 vote226 views1 answer
Vba first line of string
VBA
1 vote223 views1 answer
Add rows to datagridview vb.net
VBA
3 votes224 views1 answer
Vba make long from two words
VBA