Code to check if cell value start with int.

Rob* · 11-23-2012, 07:04 AM

Hi.

I have a little problem I cant find a solution to.

I want to use some kind of if statement to check if a cell contains a word starting wiht "int" or "Int"
Cell value can be Intern, international, Internet, Intranet, Intellect, interesting or any other word starting with "int"
I tried:

If Sheets("Sheet1").Range("A1") = "Int*" Or Sheets("Sheet1").Range("A1") = "int*" Then
MsgBox ("Yes!")
Else
MsgBox ("No!")
End If

But it sems like the wildcard * doesn't work here.
How do I do this?

**nilem** · 11-23-2012, 07:17 AM

Option Explicit
Option Compare Text

Sub tt()
If Range("A1").Value Like "int*" Then MsgBox "Yes!" Else MsgBox "No!"
End Sub

**martindwilson** · 11-23-2012, 07:18 AM

try using "like"

Sub test()
If Sheets("Sheet1").Range("A1") Like "Int*" Or Sheets("Sheet1").Range("A1") Like "int*" Then
MsgBox ("Yes!")
Else
MsgBox ("No!")
End If
End Sub

**Bishonen** · 11-23-2012, 07:19 AM

Sub lol()

If Mid(Range("A1"), 1, 3) = "int" Then
    MsgBox "yes"
    Else
    MsgBox "no"
End If

End Sub

Rob* · 11-23-2012, 07:56 AM

Ah!!

Why didn't I come up with the Like function. Been using that long time ago.
Thanks a thousand times to all you who replied.

Code to check if cell value start with int.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Code to check if cell value start with int.

Re: Code to check if cell value start with int.

Re: Code to check if cell value start with int.

Re: Code to check if cell value start with int.

Re: Code to check if cell value start with int.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions