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

1 vote383 views1 answer
Excel vba get column number from column name
VBA
0 vote361 views3 answers
Write to text file vb.net
VBA
4 votes333 views2 answers
Vba create folder if not exist
VBA
0 vote377 views1 answer
Excel web scraping
VBA
0 vote332 views2 answers
Excel vba protect cells with formula
VBA
0 vote328 views1 answer
Vb net check if file exists
VBA
0 vote346 views1 answer
Send text to clipboard vb.net
VBA
0 vote331 views1 answer
Find the name of the last excel sheet vb
VBA
1 vote318 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
2 votes339 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA