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 vote161 views1 answer
Vba run command
VBA
0 vote160 views1 answer
Vba shape transparent
VBA
1 vote159 views1 answer
How to put a gridpain in a vbox
VBA
-1 vote148 views1 answer
Text to speech vb.net
VBA
0 vote167 views1 answer
Excel vba automatic calculation
VBA
-1 vote161 views1 answer
Vba code to add new column in table
VBA
0 vote179 views1 answer
Vba round to 2 decimals
VBA
0 vote161 views1 answer
Vba boolean to string
VBA
0 vote154 views1 answer
Vbnet get file name from path
VBA
0 vote159 views1 answer
Excel vba Column Name from Column Number
VBA