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 vote146 views1 answer
Excel vba copy range with filter
VBA
-1 vote146 views1 answer
VBA check if a cell contains a letter or string
VBA
2 votes151 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote117 views1 answer
How to make a if statement with vbs
VBA
1 vote143 views1 answer
Excel vba hide zero values
VBA
5 votes151 views1 answer
Xl vba double quotes in string literal
VBA
0 vote151 views1 answer
Vba file chooser
VBA
0 vote156 views1 answer
Vbscript Trim
VBA
3 votes143 views1 answer
Vba folderexists
VBA
8 votes146 views1 answer
Excel vba make a short integer from two bytes
VBA