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

4 votes287 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
-1 vote264 views2 answers
How close excel through visual basic
VBA
0 vote291 views1 answer
Vbnet click on dgv cells
VBA
1 vote297 views1 answer
Vb.net get name by Selection Changed
VBA
1 vote309 views1 answer
How to put a gridpain in a vbox
VBA
0 vote283 views1 answer
Vba find sub dictionary
VBA
2 votes294 views1 answer
Vba file from path
VBA
5 votes329 views1 answer
Excel vba get user selected range
VBA
0 vote295 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote312 views1 answer
Sort dictionary by key vba
VBA