Wildcard in IF statement

I am having a hard time finding information on how to use this wildcard in a IF statement.

If ActiveCell.Value = "*TLPH*" Then
 ActiveCell.Offset(0, 9).Value = "1"

I have a column I'm adding a value to another cell if a piece of text is found in the column I'm looking in. The * is not working at all.