I would like to create a macros that asks the user for an "input" like with a prompt box. The Macros will search through the worksheet and replace the input by deleting whatever cells it is in.
I would like to do this twice, with two different inputs.

I was wondering if one could do this with partially complete inputs..
For instance I enter "red" in the prompt box, and it finds and deletes all cells with instances of "red dog" and "red" and "red tie".

Thank you so much for your help in advance.