AutoFilter Custom Dialog
 

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

AutoFilter Custom Dialog
 

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.

--
Regards,
Tom Ogilvy

"AlexJ" wrote in message
...
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