Search Form using First and Last name and display data

Hi guys! This is my first time posting here asking for some help. I'm very new to Excel VBA so any help you can provide will be very much appreciated. I've searched the forum threads before posting this (I can't seem to find a similar, solved issue so I decided to post this).

Attached sample of the search form I need to work on. We already have a workbook that saves data thru user form. I need to integrate the search and display functionality to that existing workbook (can't attach it here due to it already contains confidential data).

Requirements:

- Search using First and Last names
- Display matching record from the database sheet to the main sheet (First Name, Last Name, Alias, Region, Status).
- If multiple records found (same first and last names on database), pop-up form where we can select the correct data to display

Thanks a lot!

Rather than having separate forms why not incorporate your search within your existing form ?
Using a listbox will mean you are searching for 'actuals' that exist and if data is sorted duplicates will exist contiguously.
A cut down version of the attached app is what I would envisage.
torachan.

Originally Posted by torachan

Rather than having separate forms why not incorporate your search within your existing form ?
Using a listbox will mean you are searching for 'actuals' that exist and if data is sorted duplicates will exist contiguously.
A cut down version of the attached app is what I would envisage.
torachan.

Yeah we are going to integrate both functionalities in one single workbook. Thanks for this; I will check it out.