The Like
operator is already available in VBA:
If "I am studying at University of Texas at Arlington" Like "*Univ*of*Texas*" Then
MsgBox "Yes, it is!"
End If
More Related Contents:
- How to find numbers from a string?
- Matching similar but not exact text strings in Excel VBA projects
- Build a Comma Delimited String
- How to extract file name from path?
- Check if a string contains another string
- Split string into array of characters?
- Call a Sub with a String
- Excel VBA: Range to String Array in 1 step
- Any method equivalent to PadLeft/PadRight?
- Turn Excel range into VBA string
- Unicode string literals in VBA
- Implementing String.Format() in VB6
- Excel: Use formula longer that 255 characters
- How to copy cells that contain certain text to another worksheet [closed]
- How to avoid using Select in Excel VBA
- Checking for #N/A in Excel cell from VBA code
- Non-web SQL Injection
- How do I base64 encode a string efficiently using Excel VBA?
- Error: “Could Not Find Installable ISAM”
- Deleting Elements in an Array if Element is a Certain value VBA
- One-dimensional array from Excel Range
- Escape double quote in VB string
- How to make safe API Timers in VBA?
- VBA: How to change the value of another cell via a function?
- Range.Find not making a difference between January and November (February and December) in VBA Excel
- EntireRow.Delete performance issue
- Test for empty string with X”” [duplicate]
- How do I get a list of unique values from a range in Excel VBA?
- How to do a “Save As” in vba code, saving my current Excel workbook with datestamp?
- How to save semi-colon delimited csv file using VBA?