String Selection Popup

Hello All,

In Excel VBA, I am trying to create a single macro that will

A) search for a string (let's say "Bay") within an entire worksheet

B) return all results of the search containing the string in a list ("Bay st", "Bay Av", "Bayview", etc.)

C) allow the user to select one entry from the list (the list would be in numbered form, perhaps in a popup, showing 1. Bay st 2. Bay Av 3. Bayview, etc

D) after the user selects an entry (let's say the user clicks Bayview), the entire row which contains the selection (Bayview) is selected

*Thanks for any solutions or advice and please not that are not an option for what I'm doing*

Much appreciated,

Nick