VBA length of string

In VBA, you can use len(string) function to find the length of the string or to count the number of characters in the string.

Example:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim strpass As String
strpass = InputBox("Enter your password:", "Password Length Checker")
If Len(strpass) < 8 Then
   MsgBox "Too short!"
Else
   MsgBox "Good length!"
End If


End Sub

Posted by: Dara | post date: 02-25-2013 | Subject: VBA for MS Excel




This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.