Show Custom AutoFilter Dialog with VBA 2007

F

Francis

Is it possible to directly open the Custom AutoFilter Dialog with VBA
in Excel 2007?

Application.Dialogs(xlDialogAdvanced).Show opens the Advanced Filter
dialog. I'd like to open the Custom AutoFilter dialog.where you can
choose equals, does not equal, etc... There seems to be only two
filter-related xlBuiltInDialog members available.
 

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

Marco to open the "Customer Auto filter dialog box" 4
Auto Filter - Custom Auto Filter 4
Opening Built-In Custom AutoFilter Dialog Box Programmatically 2
Excel 2003 - Save as dialog box 1
Enable autofilter in protected worksheets in Excel 2000 6
Turn off Autofilter but leave rows hidden. 3
autofilter - custom... 2
Open "xlDialogChangeLink" Dialog with VBA/VB.Net 5

Top