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 vote166 views1 answer
Sendkeys vba selenium
VBA
0 vote162 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
0 vote154 views1 answer
Vba get workbook name
VBA
0 vote143 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote154 views1 answer
Vba sheet visible
VBA
3 votes157 views1 answer
Vba request json
VBA
1 vote157 views1 answer
How to put a gridpain in a vbox
VBA
0 vote157 views1 answer
Vba compare strings
VBA
0 vote168 views1 answer
Thread sleep vb
VBA
0 vote151 views2 answers
Get excel file from email attachment in vba
VBA