Use Like to compare strings : Like « String Functions « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
VBA / Excel / Access / Word » String Functions » Like 
Use Like to compare strings
 
Sub CompareStrings()

    Dim strString1 As String
    Dim strString2 As String
    
    strString1 = "Microsoft"
    
    If strString1 Like "Micr*" Then
    Debug.Print "True"
    End If
    
    If strString1 Like "Mic*t" Then
    Debug.Print "True"
    End If
    
End Sub

 
Related examples in the same category
1.Wild Cards Used to Build Patterns with Like
java2s.com  |  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.