create an input box

[Guest]

How can I create an input box that will enter a criteria for a macro that searches the spreadsheet?

 

[Mudface]

In your code add the following lines (or variant thereof):-

Dim myCriteria As String

myCriteria = InputBox("Please enter criteria")

Then use myCriteria as a variable in the rest of your macro. Hope that helps.