Problem with InputBox and MsgBox in Search- Excel 2010

Can anyone help with an issue I have? I have constructed, with diligent work, a worksheet (single) search on an input box.
2 problems:

1. My inventory workbook is more than 1 page and I would like to search for partial text in all sheets.
2. When the output of the inputbox is empty, it throws a debug error and I have tried placing a MsgBox to catch this.
Now the MsgBox loads first although it is not in the code first.

Help?

Debbie

Here is what I have right now. It is definitely not I assume in the correct order.

All my different tries are quoted out of the macro.

Please Login or Register  to view this content.