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 vote121 views1 answer
Add control vb
VBA
1 vote139 views1 answer
Vb.net get name by Cell Click
VBA
4 votes124 views1 answer
Excel vba how to reset usedrange
VBA
0 vote118 views1 answer
Do while not vb.net
VBA
8 votes238 views1 answer
Vba make a short integer from two bytes
VBA
0 vote120 views1 answer
Excel vba saveas no prompt for overwrite
VBA
1 vote119 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote116 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote128 views1 answer
Vba dictionary length
VBA
0 vote136 views1 answer
Excel vba named range exists
VBA