AutoFilter Custom Dialog

A

AlexJ

All,
Is it possilbe to access the "Custom" filter Dialog box
that is available when the user manually selects the drop-
down in an autofiltered field header.

I have review the list of built-in dialogs and could not
locate it.

TIA,
AlexJ
 
T

Tom Ogilvy

Sub Tester2()
Application.ExecuteExcel4Macro "FILTER?(1,""*A*"")"
End Sub

the 1 pertains to which column. the ""*A**"" would produce contains A,
alter to suit your needs. The autofilter dropdowns should already be
visible on the active sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exclude header row when copying autofilter results? (XL2003) 1
Marco to open the "Customer Auto filter dialog box" 4
Auto Filter - Custom Auto Filter 4
Turn of Autofilter Arrows? 20
Opening Built-In Custom AutoFilter Dialog Box Programmatically 3
Autofilter Criteria not filtering when using NOW() 16
cycling through all the possible criteria in an autofilter column 2
If/Elseif AutoFilter Macro 4

Top