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 vote151 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote139 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote142 views1 answer
Selecttoken em vbnet e json
VBA
0 vote165 views1 answer
Iterate all file in a folder vba
VBA
0 vote140 views1 answer
Vba get text file content
VBA
0 vote149 views1 answer
Average vba
VBA
0 vote150 views1 answer
Vba remove last vbcrlf
VBA
2 votes142 views1 answer
Excel vba check if key is in collection
VBA
1 vote138 views1 answer
If inputbox cancel vba
VBA
0 vote145 views1 answer
Vba string start with
VBA