| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
display edit | fill series dialog box
I want to create a macro where I display the EDIT | Fill |
Series dialog box. I don't want to do anything more than that. Does anyone know how I can do that? I am using XL 2002. Thank you for your help. Perry |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
display edit | fill series dialog box
Application.Dialogs(xlDialogDataSeries).Show
-- HTH, Dianne Butterworth Perry Kew wrote: I want to create a macro where I display the EDIT | Fill | Series dialog box. I don't want to do anything more than that. Does anyone know how I can do that? I am using XL 2002. Thank you for your help. Perry |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
display edit | fill series dialog box
Thank you very much for your help.
-----Original Message----- Application.Dialogs(xlDialogDataSeries).Show -- HTH, Dianne Butterworth Perry Kew wrote: I want to create a macro where I display the EDIT | Fill | Series dialog box. I don't want to do anything more than that. Does anyone know how I can do that? I am using XL 2002. Thank you for your help. Perry . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
display edit | fill series dialog box
Perry
Try Application.CommandBars.FindControl(, 870).Execute -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Perry Kew" wrote in message ... I want to create a macro where I display the EDIT | Fill | Series dialog box. I don't want to do anything more than that. Does anyone know how I can do that? I am using XL 2002. Thank you for your help. Perry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit Link Dialog Box | Excel Discussion (Misc queries) | |||
| Edit/Fill/Series on Protected Sheet | Excel Discussion (Misc queries) | |||
| Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
| Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
| Edit / Fill / Series | Excel Discussion (Misc queries) | |||
Hybrid Mode
