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 vote229 views1 answer
Search in richtextbox vb.net
VBA
0 vote252 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
1 vote228 views1 answer
Excel vba get ordinal number from cardinal number
VBA
2 votes220 views1 answer
Excel vba date to string conversion
VBA
1 vote255 views1 answer
Vb.net get name by Cell Click
VBA
2 votes214 views1 answer
Vba array contains
VBA
0 vote226 views1 answer
Vbnet find highest value in chart
VBA
0 vote243 views1 answer
Excel vba convert cells address
VBA
0 vote243 views1 answer
Vba sheet hide unhide
VBA
0 vote217 views1 answer
Check range is in another range vba
VBA