Combine two codes to make one!

Hello All,

I have a search code courtesy of (Bakerman2) below (code) that finds the name of an employee in a ListBox on a Worksheet. The code works great so no problem there.

I had a previous code that when the user enters the employees name it would ask "Is ______ the name you were searching for?

Is there a way to combine both to attain that in this code?

1. Find the name searched for
2. Ask if the name that it has found is the name being looked for... because it may find more then one John Smith in the list.

I added this line to the code but does not do the job - Answer = MsgBox("Is " & "*.*" & " the employee you are searching", vbYesNoCancel, "VALIDATE RESULT")

Please Login or Register  to view this content.

Any thoughts?

Regards,

John

Please Login or Register  to view this content.