View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] nkjsterk@hotmail.com is offline
external usenet poster
 
Posts: 4
Default Opening Built-In Custom AutoFilter Dialog Box Programmatically

Hello,

I would like to know if it possible to open the built-In Custom
AutoFilter dialog box programmatically.

Manually I get it through selecting a filtered field, followed by
choosing "Custom..." in the pull down list. The automatic solution is
not in the help files as far as I know.

By the way,

Application.Dialogs(xlDialogFilter).Show

and

Application.Dialogs(xlDialogFilterAdvanced).Show

are not the one I exactly need. Is there a workaround?

Thanks in advance,

Nico Sterk