Can a Macro utilize an auto filter?
 

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?

Can a Macro utilize an auto filter?
 

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?

Can a Macro utilize an auto filter?
 

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?

Can a Macro utilize an auto filter?
 

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?

Can a Macro utilize an auto filter?
 

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?