VBA Popup to search a sheet and delete rows based on keyword entered

Hi,
I am pretty new to VBA, and have been feeling around in the dark trying to figure this out. What I am looking to do is create a macro button that causes a popup (on Sheet 1) , that will ask you what name you want to delete, and have it search a list of names (Sheet 3) and delete the row based upon the keyword search. I really do not even know where to begin, if someone can help get me in the right direction that would be awesome. Thanks!

Please let me know if I can help provide more information, or if I am unclear as to my needs.

This should be simple, but for the best solution it would help to see some dta.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Thanks for the sound advice,

Here is the dummy workbook. I know my code looks all crazy for the other things I have going on. (Alphabetization of the names ect.) If you have any suggestions as to running my code more efficiently please feel free to make other suggestions as well.

But as far as my MAIN CONCERN goes, the popup window would go on the first page where I have the text located, and it would search and clear the contents of the rows on "page 3" (*NOT DELETE*) based on the keyword entered into the popup box.

Thanks again.

Are there going to be multiple instances of the same name on Sheet3?
General:
You need to remove all the unused UserForms & any empty code modules.
The code that you have is all recorded & requires tidying up - you don't need Selections, SmallScroll etc

I've added a userform to delete the selected row.

Also I've amended a couple of the codes to show you how to edit the recorfed macro. However, the code will only work on the ranges coded in, if you want it to work on different ranges then a different approach would be needed.