VBA Search Database Excel 2007 Help or Tips

[Excelnoub]

Good morning Guys,
I am looking for any kind of template for Contact information search.

I have built one of my own, with some help, but it is not doing what I want.

My Sheet1 (Contact Information) is where I do my search (Macro buttons). I have a Textbox where I add my Search string and I click on another macro button to start the search. But the problem is I could have duplicated names and would like to have a pop-up that would ask me which one to choose.

Example:
Search for: John Doe

I have 49 John’s.

Then it would bring forward a pop-up, or whatever, and ask me with one to choose then continue my code in copy and pasting the information in my sheet1.

I need to do this for all my columns in my sheet2, example if someone need to search by number, email address or name or whatever.

Is there a pre-made example I could use or have tips to built my Search database from?

Guidance or tips would be nice.

Thank you,

I have attached my Workbook that would tell you an idea of where I need to go with this.


Contact Databasetest.xlsm

[Excelnoub]

Any Guidance or help would be appreciated.

If more info is required let me know I will be glad to provide some.

I thought that Microsoft would already have a similar template, but nothing I saw on the site as of yet.