create an input box

Mar 5th, 2002, 01:25 PM

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

Mudface · Mar 5th, 2002, 01:29 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 01:25 PM	#1
Guest Posts: n/a	How can I create an input box that will enter a criteria for a macro that searches the spreadsheet?

Mar 5th, 2002, 01:29 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	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.