autofilter dialog boxes - can i call this up in the

[Mr BT]

middle of my script?
I would like my script to do other things before I call the autofilter
dialog box up on the screen. But I'm not sure HOW to call it up.

I've been using the following as my base to call up autofilter but it
doesn't seem to work:

Call Application.Dialogs(xlDialogFormulaReplace).Show

so I'm hoping someone here can assist me.

Thank you in advance

 

[Héctor Miguel]

hi, !

middle of my script?
I would like my script to do other things before I call the autofilter dialog box up on the screen.
But I'm not sure HOW to call it up.
I've been using the following as my base to call up autofilter but it doesn't seem to work:
Call Application.Dialogs(xlDialogFormulaReplace).Show
so I'm hoping someone here can assist me.
Thank you in advance

use the (ancient ?) xl4 macro-functions to "ask/show" *that* dialog to the user...
previously "send" a keystroke sequence to the parameters "preparation"...
and let the user to finish the job (i.e.)

assuming column E is the 5th filtered field in your layout...

Sub Show_CustomFiterDialog()
SendKeys "+{tab}{down}{end}{up}{tab}"
ExecuteExcel4Macro "filter?(5)"
End Sub

there are several ways to "show all" and/or quit the autofilter mode

hth,
hector.

 

[Mr BT]

hi, !


use the (ancient ?) xl4 macro-functions to "ask/show" *that* dialog to the
user...
previously "send" a keystroke sequence to the parameters "preparation"...
and let the user to finish the job (i.e.)

assuming column E is the 5th filtered field in your layout...

Sub Show_CustomFiterDialog()
SendKeys "+{tab}{down}{end}{up}{tab}"
ExecuteExcel4Macro "filter?(5)"
End Sub

there are several ways to "show all" and/or quit the autofilter mode

hth,
hector.

Dude that works great!
thanks for your help

Mr BT

 

[Héctor Miguel]

hi, !

Dude that works great!
thanks for your help

Mr BT

thanks for your feed-back

regards,
hector.

__ OP __