View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default How to show 'Custom Auto Filter' dialog?

I suspect you would be able to use the Application.Dialogs() function, but I
do not believe there is one for the filter selection drop down
Alternatively create your own userform and simulate the selection, then
apply this directly to the filter criteria settings.



--
Cheers
Nigel



"michael.beckinsale" wrote in message
oups.com...
Hi all,

What l would like to do using VBA is show the 'Custom Auto Filter'
dialog and additionally set the
'Show rows whe' to 'begins with'

Once the form is showing with the default as above l want to exit the
macro and pass control to the user. They would then enter the 'begins
with' criteria click OK and the rows would be filtered accordingly.

Any help in coding this / pointing me in the right direction gretafully
appreciated.

Regards

Michael Beckinsale