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

1 vote131 views1 answer
If inputbox cancel vba
VBA
5 votes147 views1 answer
Excel vba right word from Long Integer
VBA
0 vote122 views1 answer
Excel vba milliseconds
VBA
1 vote150 views1 answer
Vba optional
VBA
0 vote133 views1 answer
Convert unix to date vba
VBA
0 vote126 views1 answer
Excel vba disable screen update
VBA
0 vote148 views1 answer
How to add line graph vb net
VBA
0 vote158 views1 answer
Vba random number
VBA
27 votes261 views2 answers
Vba check if file exists
VBA
0 vote136 views1 answer
Excel vba prevent saving workbook
VBA