Adding control box to VBA

I'd like to make this macro interactive by adding a box to select column and text with wildcards
Currently I change the "F" and the "*:*" in the code below and then run the macro. But, I'd like to make it interactive so others with no experience with vba can do it.

Any help greatly appreciated.

Jim

rows in macro that are affected
With .Cells(Lrow,"F") ‘insert column
If Not IsError(.Value) Then
If .Value Like "*:*" Then .E. . . .

Please Login or Register  to view this content.

Thanks for the response Marvin
I'm not great with VBA - I try to find working code to our applications and then string codes together. I've not created an Input box for this type of application. Could you help me out with the how.
Input Column & Input text to look for (if text found delete row)

Thanks again

Thanks Marvin - this part works great but need input box to declare this line
If .Value Like "*:*" Then .EntireRow.Delete

The *:* could be anything desired - so how could I incorporate that query?

This is sweat Marvin - works like a charm in so many ways. Can't thank you enough
Jim