builtin dialog box and arguments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to display the excel builtin dialog box "subtotalcreate" and have the
"at change in", "function number", and "total" arguments preassigned values.
The user would not have to choose them from their lists, just click "ok" or
"cancel". Is there a way to do this? Please include syntax.
If this isn't possible, is it possible to replicate in VBA code what the
"subtotalcreate" dialog box does? The user would not see any dialog box at
all but the subtotaling would occur based on the assigned values that I would
use.

Thanks,
Randy
 
Turn on the macro recorder (Tools | Macro > Record new macro...), do
whatever you want using the GUI, and turn off the recorder. In a vast
majority of the cases, XL will give you the necessary code.

Do keep in mind that in XL about all that is possible with the built-in
dialog boxes is to show them.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

BuiltIn dialogs value 1
Argument list of Dialog box objects show method 1
Dialog Box Buttons 1
Progmatically set "Application.Dialogs(xlDialogFormulaFind)" optio 3
Excel 2003 - Save as dialog box 9
Dialog Box and mouse selection 2
Worksheet Delete method's dialog box 3
Dialog Box with Multiple Items 2

Back
Top