modify userform search to search the whole wookbook instead of single sheet

Hi Guys,

Please could someone help me?

I would like to edit this code so it searches the whole workbook instead of searching on 1 worksheet.

Here is my code:

Please Login or Register  to view this content.

Any help would be much appreciated.

Kind Regards

Dan

Hi Sintek,

Thank you for helping me but unfortunately your code hasn't worked.

When I enter the PO it just comes up with the message box "INCORRECT DATA ENTRY"

Any Ideas or would you like me to upload my file?

Thanks again

Dan

Ok, here's my file.

Hi Sintek,

Thank you, it work perfectly.

Kind Regards

Dan