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 vote134 views1 answer
Reset border color textbox vba
VBA
0 vote125 views1 answer
Vba sheet visible
VBA
0 vote125 views1 answer
Vba integer to double
VBA
0 vote71 views1 answer
Excel autofilter vba
VBA
0 vote130 views1 answer
Rotate image by any angle vb.net
VBA
0 vote131 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote130 views1 answer
How to mount floppy disks in vb.net
VBA
1 vote126 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote122 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote130 views1 answer
Vba add spaces
VBA