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

In article ,
says...
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