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 vote250 views1 answer
Vba string
VBA
0 vote233 views1 answer
Change whcih control a user has selected vb
VBA
0 vote248 views1 answer
How to use if condition in time vba
VBA
0 vote259 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
6 votes244 views1 answer
Excel vba isalpha
VBA
1 vote238 views1 answer
Excel vba compare 2 rows
VBA
0 vote229 views1 answer
Excel vba assign shortcut key to button
VBA
2 votes230 views1 answer
Excel vba check if key is in collection
VBA
0 vote230 views1 answer
Open application from vbnet
VBA
0 vote238 views2 answers
Delete all controls from list of control vb.net
VBA