macro to select a cell after performing a search (Attached)

Would someone be kind enough to tell me how to mod the code below?
I have also attached the workbook if it helps at all.

The code below works fine if I enter a search term that resides in column C and run the macro, it then selects a cell in the column to the left B, on the same row so that I can enter a quantity.

I have two problems:
If I enter a search term that resides in column A the macro fails because it can’t select one cell to the left.
Is it possible to make the resulting search select the cell in column B?
Example: Search results in C4 and cell B4 is selected or Search results in A5 and B5 is selected.
The auto selected cell should always be in column B

Also, if I enter a search term on a word or letter that doesn’t exist, it fails.
Example: There is no letter x in the ranges so searching on x would fail.
Would it be possible to display a msg box saying not found, instead of the macro failing?

In short...
Search on column B and C, if the result is C7 or A7, then the macro would automatically select B7
If a search term that doesn’t exist is entered into the search box, a message box opens displaying something like “Not Found”.

Please Login or Register  to view this content.