I am trying to write a code to match up with a user form

I want to be able to seach a certain range for a value in a user for and if
it is not what i am looking for delete the whole row.

I need to be able to do this for
=number
<number and number
contins text
matches drop down list

Thank you