Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marco to open the "Customer Auto filter dialog box"
The issue I've encountered is that the macro recorder can't be stopped
with the Custom Autofilter Dialog Box open. Is it possible to create a macro to select "(Custom...)" from the drop down list, and have the dialog box appears ready to enter what needs to be sorted. Thanks very much ... its driving me MAD ! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marco to open the "Customer Auto filter dialog box"
If you're using the macro recorder, you can just close the dialog box and
then stop the recorder. Then go back and edit your code, deleting everyting that appears after the line opening the dialog box. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marco to open the "Customer Auto filter dialog box"
On 31 July, 16:59, arjen van... wrote:
If you're using the macro recorder, you can just close the dialog box and then stop the recorder. Then go back and edit your code, deleting everyting that appears after the line opening the dialog box. Thanks, but i cant work out what needs to be deleted, there is very little there. Can you show me a copy. regards J |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marco to open the "Customer Auto filter dialog box"
I think I understand your question now, you just want the dialog box to
display so the user can enter their own criteria and then carry on with the procedure. Macro recorder doesn't give the dialog box name and I don't know it. For a list of all dialog boxes, in Visual Basic Editor hit F2, then click on Classes and xlBuiltInDialog in the list. Actually, I'm not sure if the list includes everything. Generally to show a dialog box, the code is: Application.Dialogs(xlDialogActiveCellFont).Show where the piece in the brackets is the specific dialog box you need. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marco to open the "Customer Auto filter dialog box"
You can look at VBA's help to see all the possible dialogs -- or use the object
browser and see a couple more that are hidden. But when I did that, I didn't see any that looked like they matched the custom autofilter dialog. I'm not saying it can't be done. But I don't see how to do it. If I _had_ to do it, I think I'd end up with a homemade userform that mimicked that dialog thingy. arjen van... wrote: I think I understand your question now, you just want the dialog box to display so the user can enter their own criteria and then carry on with the procedure. Macro recorder doesn't give the dialog box name and I don't know it. For a list of all dialog boxes, in Visual Basic Editor hit F2, then click on Classes and xlBuiltInDialog in the list. Actually, I'm not sure if the list includes everything. Generally to show a dialog box, the code is: Application.Dialogs(xlDialogActiveCellFont).Show where the piece in the brackets is the specific dialog box you need. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Filter - how to collapse "non-blank" cells in a column? | Excel Discussion (Misc queries) | |||
My File Open Dialog is "permanently" maximised | Excel Discussion (Misc queries) | |||
Add "Favorites" to the file open dialog box | Setting up and Configuration of Excel | |||
Suppress "Disable/Enable Macros" and Query Refresh dialog on open | Excel Programming | |||
How do I show Auto-Filter "Search" Criteria on Sheet1? | Excel Programming |