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 vote191 views1 answer
Vba date to unix timestamp
VBA
1 vote195 views1 answer
Vba login website
VBA
0 vote183 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote180 views1 answer
Vba format currency
VBA
0 vote188 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote188 views1 answer
Vba add shape oval
VBA
8 votes269 views1 answer
Excel vba make word from bytes
VBA
1 vote164 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote185 views1 answer
Openfiledialog specific folder
VBA
0 vote180 views1 answer
Select case vba
VBA