View Single Post
  #7 (permalink)  
Old October 25th, 2004, 05:09 AM
gcianfanelli gcianfanelli is offline
Authorized User
 
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you're sure it's a string value:

Code:
  If myCell.Value Like "*shoes*" Then
    'do something
  End If


or

Code:
  If InStr(1, UCase$(myCell.value), "SHOES", vbTextCompare) Then
    'do something
  End If
Reply With Quote