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

0 vote213 views1 answer
Telephon call in vba
VBA
0 vote267 views1 answer
Vba dictionary clear
VBA
0 vote242 views1 answer
.net crash app
VBA
1 vote207 views1 answer
Excel vba get column name from number
VBA
5 votes222 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote275 views1 answer
Excel vba delete columns in range
VBA
-1 vote230 views1 answer
Vba sendkeys
VBA
0 vote232 views2 answers
Delete all controls from list of control vb.net
VBA
5 votes215 views1 answer
Excel formula how to create strings containing double quotes
VBA
1 vote237 views1 answer
Excel vba first row in range
VBA