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 vote321 views1 answer
Vb ternary
VBA
20 votes448 views1 answer
Excel vba recursive example factorial function
VBA
1 vote328 views1 answer
Random number generator vb.net
VBA
0 vote333 views1 answer
Create links in msgbox in vb
VBA
0 vote351 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote325 views1 answer
Excel vba disable screen update
VBA
31 votes449 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote302 views1 answer
Vba line feed
VBA
0 vote330 views1 answer
Vba character ascii code
VBA
0 vote312 views1 answer
Vbnet add axis labels to chart
VBA