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 vote277 views2 answers
Checking and changing system volume vb.net
VBA
-1 vote216 views1 answer
For i in range vba
VBA
2 votes247 views2 answers
Excel vba if sunday or staurday
VBA
11 votes497 views1 answer
Excel vba How to URL encode a string
VBA
0 vote220 views1 answer
Vba run command
VBA
0 vote296 views1 answer
Vba dictionary clear
VBA
0 vote236 views1 answer
Convert number to minutes in vba
VBA
0 vote227 views1 answer
Excel named range sum
VBA
0 vote209 views1 answer
Excel vba disable alerts
VBA
0 vote223 views1 answer
Loop through each cell in dgv vbnet
VBA