Choose Certain Words In An If Statement

[charllie]

Hi Folks,

I have a textbox in a userform that will be the title of certains DVD's etc. I want to be able to identify certain words within that title.

For Example:

DVD title is "The Star Trek First Edition"
I want to be able to just pick up on the words "Star Trek" so if a sentance contains these words i can perform certain actions.

I can use the following code which does work if the words "Star Trek" only are used.

If Me.TextBox14.Text = "Star Trek" Then
        Me.TextBox10.Text = "10"
    Else
        Me.TextBox10.Text = "20"
    End If

Can anyone help me with this please, is it possible or isthere another way around it?

Thanks

 

[Oorang]

If instr(Me.TextBox14.Text,"Star Trek") <> 0 Then
Me.TextBox10.Text = "10"
Else
Me.TextBox10.Text = "20"
End If

 

[charllie]

Hi Ooang,

Thank you very much for the code, that woks just as required.

I appreciate your help.

Thanks