Custom list for autofiltering

[fddekker]

With VBA code, I have limited the autofilter function to 1 column.
Is it possible to create a limited pulldown criteria for the filter, e.g.:

<=-75%
<=-50%
<=-25%
>=25%
>=50%
>=75%

In stead of
(All)
(Top 10 ...)
(Custom ....)
...


Thanks in advance,

Francois

 

[SkipVought]

Hi,

Why not use a combobox. Use the selection result to apply a custom criteria.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

...for that matter, you could use a Data > Validation - LIST control, rather than a Combo.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[fddekker]

Hi Thanks for the response.

That is what I am doing at the moment, but would like VB code to just bring up the autofilter selection arrow and then the limited list.

(I am using a combo box -- populate a control cell, then with index get the value. But it requires to specify the filter criteria everytime, so there is no automatic refresh when a new criteria is selected. I would like the user to just click on a filter value and see the result automatically redisplayed.

I see a company called XLGEN created something like that.)

 

[SkipVought]

"But it requires to specify the filter criteria everytime, so there is no automatic refresh when a new criteria is selected."

I do not understand.

The user selects a new criteria from your special combobox.
Your procedure fires on the click event.
In your procedure, YOU assign the new criteria to the AutoFilter and...

VOLA!!

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}