User form Search Not Working When Sheet is Changed

[KOBBY123]

I have a an Excel workbook with 3 sheets - Sheet1- ProcessedPV, Sheet2- Examined Staff and Sheet3. I have used sheet3 as login interface and intend to hide the other two sheets. I have a userform that searches sheet1 and displays data stored in sheet1 into a listbox. My challenge is, whenever I hide sheet1 and display the userform on sheet3, my userform does not respond to the search command unless I display the userform on sheet1. Attached is my file

[LeoTaxi]

Please Login or Register  to view this content.

Kind regards
Leo

[KOBBY123]

Wow that's great Leo. It worked like magic. Am most grateful bro. God bless!!!

[LeoTaxi]

no thanks,

if you have no more questions, please mark the case as solved

Kind regards
Leo