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

3 votes272 views1 answer
Excel vba last row in range
VBA
0 vote315 views2 answers
VB
VBA
2 votes293 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
15 votes394 views2 answers
Xl vba dynamic string array
VBA
7 votes312 views1 answer
Vba array declaration
VBA
1 vote289 views1 answer
Vba refresh pivot table
VBA
0 vote298 views1 answer
.net crash app
VBA
0 vote324 views1 answer
Vba nested dictionary
VBA
0 vote309 views1 answer
How to format a textbox as date vb net
VBA
0 vote318 views1 answer
Make your computer talk vbscript
VBA