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 vote136 views1 answer
Vba listindex select multiple items vba
VBA
0 vote168 views1 answer
Vba collection contains
VBA
1 vote160 views2 answers
Vba remove first 2 characters from string
VBA
0 vote179 views1 answer
Vba keep command window open
VBA
0 vote178 views1 answer
Vba change active sheet
VBA
0 vote175 views1 answer
Worksheet.pastespecial textbox
VBA
5 votes187 views2 answers
Excel vba write to the windows registry
VBA
0 vote169 views1 answer
Vbs write file
VBA
1 vote191 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
0 vote186 views1 answer
Vba round to 2 decimals
VBA