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

4 votes336 views1 answer
Vba create directory
VBA
0 vote328 views1 answer
Vb run command
VBA
3 votes363 views1 answer
Vba post request json
VBA
1 vote333 views1 answer
Extract the second word in a text in excel
VBA
1 vote364 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote329 views1 answer
Vba change named range address
VBA
0 vote384 views1 answer
How to call gcd in vba
VBA
0 vote325 views1 answer
Excel vba show developer tab
VBA
18 votes485 views3 answers
Excel-vba make integer
VBA
0 vote319 views1 answer
Refresh token em vb net
VBA