Searching a Closed Workbook ?

Ken:

I've attached the project here.

I did originally leave off the code that is in the Module. Sorry about that ... thought just the UserForm code would be sufficient.

This project is based on Chip Pearson's example.

I managed to get it working for a short time when there was only 20 or so rows of data, on WorkSheet2 of this same WorkBook. When complete there will be just over 1 million rows of data to be searched in a separate workbook, always on sheets 2 and 3. Always searching column A of those two sheets.

Speed in returning the data of the search is paramount, as is using a closed workbook where the data will be stored.

I've played around with some code to try and hide the second workbook or at least make it invisible while the search is happening. Not alot of success there either. Haven't tried getting the data workbook (#2) minimized (another option).

I'm looking forward to learning from your suggestions. I'm a newbie with VBA. I've learned alot in the past month, but not enough to get me where I want to go with this project.

Thank you for your interest.