non-case sensitive 'string' search?

@intothewind

Heres a link explaning the Instr function http://www.aivosto.com/vbtips/instr.html
Jakes solution will work. Did you try it? Here's a couple of examples.

Sub abc()
 s = "FiLMiNg"
 
 ' Lcase will turn FiLMiNg into filming therefor will be like filming
 If LCase(s) Like "*filming*" Then MsgBox "Like filming"
 
 ' Ucase will turn FiLMiNg into FILMING therefor will be like FILMING
 If UCase(s) Like "*FILMING*" Then MsgBox "Like FILMING"
End Sub