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 vote180 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote181 views1 answer
Excel vba remove formatting from cell
VBA
0 vote198 views1 answer
Vba listbox remove all items
VBA
0 vote205 views1 answer
Vba random number
VBA
0 vote184 views1 answer
Vba test optional argument
VBA
1 vote208 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
5 votes208 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote182 views1 answer
Hello world vb.net
VBA
3 votes178 views1 answer
Vba folderexists
VBA
0 vote185 views1 answer
Vba boolean to string
VBA