This is the simple way:
If InStr(SourceC.Text, "word1") Or InStr(SourceC.Text, "word2") Then
form2.Show()
Me.Hide()
Else
form1.Show()
Me.Hide()
End If
If you're using VB.Net, you can also make use of regular expressions:
If System.Text.RegularExpressions.Regex.IsMatch(SourceC.Text, "word1|word2") Then
form2.Show()
Me.Hide()
Else
form1.Show()
Me.Hide()
End If
When you get a little more familiar with regular expressions, you can also make that a bit shorter:
If System.Text.RegularExpressions.Regex.IsMatch(SourceC.Text, "word[12]") Then
form2.Show()
Me.Hide()
Else
form1.Show()
Me.Hide()
End If
Though I'm guessing your needs are not quite that specific. Also, some of that code might have to change depending on if you want to make sure BOTH the words appear at the same time, and if overlaps count (e.g., if the word "word12" will count towards both "word1" and "word12", because the former is a subset of the latter). Also, you could use "Contains" rather than "InStr".