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 vote236 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
3 votes225 views1 answer
Vba request json
VBA
13 votes298 views2 answers
Vba write text file
VBA
1 vote239 views1 answer
Vba reverse string
VBA
3 votes271 views1 answer
Vba continue for each loop
VBA
3 votes244 views1 answer
Vba not equal
VBA
0 vote235 views1 answer
Search combobox items vb.net
VBA
0 vote238 views1 answer
Vba get workbook name
VBA
0 vote238 views1 answer
VB Error Code BC30201
VBA
0 vote246 views1 answer
Weekday vba
VBA