HELP :( Search a range of cells from contents of another

If I have something written in cell A1...

Then I have a button I created...

So lets say I type something (anything) in cell A1 and press the button, I want it to search a range of cells say (column B) to see if what I entered into cell A1 is in Column B.

However, if I enter in the word "Bomb" in cell A1... if Column B has a cell with the words "Bomb Squad" or even lower case "bomb" I want it to prompt a message box saying whatever i choose.

Please Login or Register  to view this content.

This just doesn't seem to be working... As soon as I put the code into VBA it prompts back a syntax error..

any other options?

It shouldn't. Perhaps a space on each side of the ampersand (&) would fix things.