Input box and filters
 

I would like to use an input box to ask a person for (up to) 2 keywords and
then copy those words to a custom filter to search through approx 10,000
lines of data.

I haven't been able to figure out how to get an input box with 2 seperate
lines for keyword entry's and then copy those words over to the 2 fields in
the custom search.

Any help would be very welcomed.

Input box and filters
 

First, try recording it and then come back with more questions.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Still Learning" wrote in message
...
I would like to use an input box to ask a person for (up to) 2 keywords and
then copy those words to a custom filter to search through approx 10,000
lines of data.

I haven't been able to figure out how to get an input box with 2 seperate
lines for keyword entry's and then copy those words over to the 2 fields
in
the custom search.

Any help would be very welcomed.

Input box and filters
 

I still haven't figured out how to get an input box with 2 seperate lines for
entering words.

Thanks.

"Don Guillett" wrote:


First, try recording it and then come back with more questions.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Still Learning" wrote in message
...
I would like to use an input box to ask a person for (up to) 2 keywords and
then copy those words to a custom filter to search through approx 10,000
lines of data.

I haven't been able to figure out how to get an input box with 2 seperate
lines for keyword entry's and then copy those words over to the 2 fields
in
the custom search.

Any help would be very welcomed.

Input box and filters
 

Sub Macro1()

firstwd = InputBox("Enter a word")
secondwd = InputBox("Enter a word")
Range("B1").Select
Selection.AutoFilter
Selection.AutoFilter Field:=3, Criteria1:=firstwd, Operator:=xlOr, _
Criteria2:=secondwd
End Sub



Gord Dibben MS Excel MVP


On Wed, 29 Apr 2009 15:14:01 -0700, Still Learning
wrote:

I still haven't figured out how to get an input box with 2 seperate lines for
entering words.

Thanks.

"Don Guillett" wrote:


First, try recording it and then come back with more questions.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Still Learning" wrote in message
...
I would like to use an input box to ask a person for (up to) 2 keywords and
then copy those words to a custom filter to search through approx 10,000
lines of data.

I haven't been able to figure out how to get an input box with 2 seperate
lines for keyword entry's and then copy those words over to the 2 fields
in
the custom search.

Any help would be very welcomed.