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

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