AutoFilter

[hughg]

Please help
Office 2004 Mac

Is there any way to make the Cusom Autofilter dialog box display with
a macro

 

[Jim Gordon MVP]

Hi,

The closest built-in dialog that I know of is the advanced filter:
Application.Dialogs(xlDialogFilterAdvanced).Show

You could make a userform and program its results to match the functionality
of the Custom AutoFilter dialog box.

-Jim

Please help
Office 2004 Mac

Is there any way to make the Cusom Autofilter dialog box display with
a macro

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[hughg]

Hi,

The closest built-in dialog that I know of is the advanced filter:
Application.Dialogs(xlDialogFilterAdvanced).Show

You could make a userform and program its results to match the functionality
of the Custom AutoFilter dialog box.

-Jim




--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP infohttp://mvp.support.microsoft.com/

Thanks for your help Jim

I have found xlDialogFilterAdvanced but I thought there might be an
easer way than making a userform which won't tab anyway

Regards
Hugh

 

[Jim Gordon MVP]

Hi,

I thought they had fixed the Tab problem at one point, but I confirm that it
has returned.

Anyone who encounters this problem should report it to Microsoft at this URL
http://www.microsoft.com/mac/default.aspx?pid=feedback&lang=en&app=Excel

This tab problem needs to be fixed!

-Jim

Thanks for your help Jim

I have found xlDialogFilterAdvanced but I thought there might be an
easer way than making a userform which won't tab anyway

Regards
Hugh

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info