I have column in my spreadsheet and it already has an autofilter associted
with it. I use the custom auto filter function to do a "contains" search for
a particualar string I am looking for. I was wondering if I could create a
macro that is associated to a button that does the same thing? I want an
un-experienced user to be able to type the string they are looking for into a
text box, click the button, and all the fields in that column that contain
the string will appear. Is this possible?

It seems that you could just tell them to select from the filter arrow.
However, to do what you want, try recording a macro and then using " &
range("a1") & " instead of the recorded reference.

--
Don Guillett
SalesAid Software

"Susan" wrote in message
...
I have column in my spreadsheet and it already has an autofilter associted
with it. I use the custom auto filter function to do a "contains" search
for
a particualar string I am looking for. I was wondering if I could create
a
macro that is associated to a button that does the same thing? I want an
un-experienced user to be able to type the string they are looking for
into a
text box, click the button, and all the fields in that column that contain
the string will appear. Is this possible?

We're worried that the filter arrow may be too many steps for a user that is
not very used to excel. In your suggestion, when recording the macro, would
I record while I did a search in the autofilter? And when I selected
"contains," what would I put in the box for what I'm searching for, the "&
range ("a1")&" reference?

"Don Guillett" wrote:

It seems that you could just tell them to select from the filter arrow.
However, to do what you want, try recording a macro and then using " &
range("a1") & " instead of the recorded reference.

--
Don Guillett
SalesAid Software

"Susan" wrote in message
...
I have column in my spreadsheet and it already has an autofilter associted
with it. I use the custom auto filter function to do a "contains" search
for
a particualar string I am looking for. I was wondering if I could create
a
macro that is associated to a button that does the same thing? I want an
un-experienced user to be able to type the string they are looking for
into a
text box, click the button, and all the fields in that column that contain
the string will appear. Is this possible?

Sub Filterbasedoncell()' from a UNfiltered range
Range("A1").AutoFilter Field:=1, Criteria1:=Range("c1") '"3"
End Sub
Sub Unfilter()
Selection.AutoFilter
End Sub

--
Don Guillett
SalesAid Software

"Susan" wrote in message
...
We're worried that the filter arrow may be too many steps for a user that
is
not very used to excel. In your suggestion, when recording the macro,
would
I record while I did a search in the autofilter? And when I selected
"contains," what would I put in the box for what I'm searching for, the "&
range ("a1")&" reference?

"Don Guillett" wrote:

It seems that you could just tell them to select from the filter arrow.
However, to do what you want, try recording a macro and then using " &
range("a1") & " instead of the recorded reference.

--
Don Guillett
SalesAid Software

"Susan" wrote in message
...
I have column in my spreadsheet and it already has an autofilter
associted
with it. I use the custom auto filter function to do a "contains"
search
for
a particualar string I am looking for. I was wondering if I could
create
a
macro that is associated to a button that does the same thing? I want
an
un-experienced user to be able to type the string they are looking for
into a
text box, click the button, and all the fields in that column that
contain
the string will appear. Is this possible?

Thanks so much for all of the extremly useful information. I have one last
question, is there a way to change the code so that it utilizes the
"contains" function in autofilter as opposed to just the criteria? If there
are multiple strings in a cell that are seperated by commas, I would like it
to still return that cell if any one of the strings is the entered criteria.
Thanks in advance for all your help.


"Don Guillett" wrote:

Sub Filterbasedoncell()' from a UNfiltered range
Range("A1").AutoFilter Field:=1, Criteria1:=Range("c1") '"3"
End Sub
Sub Unfilter()
Selection.AutoFilter
End Sub

--
Don Guillett
SalesAid Software

"Susan" wrote in message
...
We're worried that the filter arrow may be too many steps for a user that
is
not very used to excel. In your suggestion, when recording the macro,
would
I record while I did a search in the autofilter? And when I selected
"contains," what would I put in the box for what I'm searching for, the "&
range ("a1")&" reference?

"Don Guillett" wrote:

It seems that you could just tell them to select from the filter arrow.
However, to do what you want, try recording a macro and then using " &
range("a1") & " instead of the recorded reference.

--
Don Guillett
SalesAid Software

"Susan" wrote in message
...
I have column in my spreadsheet and it already has an autofilter
associted
with it. I use the custom auto filter function to do a "contains"
search
for
a particualar string I am looking for. I was wondering if I could
create
a
macro that is associated to a button that does the same thing? I want
an
un-experienced user to be able to type the string they are looking for
into a
text box, click the button, and all the fields in that column that
contain
the string will appear. Is this possible?