List of the builtin dialog arguments

Frank Arendt-Theilen

unread,

Jan 13, 2000, 3:00:00 AM1/13/00

to

I am searching for a list of the arguments of the builtin dialogs,
which discribes the datatype of each argument. Where can I get it?
Regards,
Frank
_______________________________________________________

Tom Ogilvy

unread,

Jan 13, 2000, 3:00:00 AM1/13/00

to

The arguments to the built in dialogs are documented in the help files for
the Excel 4 macro language:

http://support.microsoft.com/support/downloads/LNP129.asp
download the file Macrofun.exe and xlmacr8.hlp (that one is toward the
bottom of the list)

Microsoft is moving all their downloads to the download center, but if you
look past that message, the links are still on the above page for now.

Regards,
Tom Ogilvy
MVP Excel

Frank Arendt-Theilen wrote in message ...

Bill Manville

unread,

Jan 13, 2000, 3:00:00 AM1/13/00

to

In article <i69r7sg9mek6dbfkh...@4ax.com>, Frank

Arendt-Theilen wrote:
> I am searching for a list of the arguments of the builtin dialogs,
> which discribes the datatype of each argument. Where can I get it?
>

Try the Excel 4 function reference manual.
Most dialogs take the same types of argument as the corresponding Excel
4 macro command.

Quite often the argument list was carried over to VBA as well, so you
could do worse that using the arguments as for the corresponding VBA
method - not foolproof though.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply to newsgroup

Jim Rech

unread,

Jan 13, 2000, 3:00:00 AM1/13/00

to

The Excel 4 help file that Tom and Bill mentioned is the best source for a
detailed explanation of what the built-in dialog arguments are. There is
also a brief listing of the arguments in VBA help. You can search on
"built-in" or in Excel 2000 run this macro to get to it:

Application.Help "VBAXL9.CHM::/html/xlmscDialogArgLists.htm"

--
Jim Rech
Excel MVP

Patrick Molloy

unread,

Jan 13, 2000, 3:00:00 AM1/13/00

to

as an alternative to Tom's answer, in the Excel VBE, open help and in the
index tab, type 'Dialogs Collection Object' & hit Display. This opens the
help sheet. At the very bottom is a link to the argument list that you're
looking for.

--
Patrick
Microsoft Excel MVP
________________

Frank Arendt-Theilen <Thei...@t-online.de> wrote in message
news:i69r7sg9mek6dbfkh...@4ax.com...

> I am searching for a list of the arguments of the builtin dialogs,
> which discribes the datatype of each argument. Where can I get it?

> Regards,
> Frank
> _______________________________________________________

Frank Arendt-Theilen

unread,

Jan 13, 2000, 3:00:00 AM1/13/00

to

Hallo Tom,
thanks, that's what I am looking for...but some dialogs have changed
and there may be some more builtin dialogs in XL8/XL9 than in XL4.
Where can I get the newest list of the builtin dialog arguments?
Regards,
Frank
________________________________________________________

Am Thu, 13 Jan 2000 07:49:54 -0500, schrieb "Tom Ogilvy"
<Thomas....@hqda.army.mil> in microsoft.public.excel.programming
zu "Re: List of the builtin dialog arguments":

>The arguments to the built in dialogs are documented in the help files for
>the Excel 4 macro language:
>
>http://support.microsoft.com/support/downloads/LNP129.asp
>download the file Macrofun.exe and xlmacr8.hlp (that one is toward the
>bottom of the list)
>
>Microsoft is moving all their downloads to the download center, but if you
>look past that message, the links are still on the above page for now.
>
>Regards,
>Tom Ogilvy
>MVP Excel
>
>
>Frank Arendt-Theilen wrote in message ...

Tom Ogilvy

unread,

Jan 13, 2000, 3:00:00 AM1/13/00

to

I don't have another source - sorry.

In Excel 97 you could get a list of arguments by searching on Built-in in
the index for the help file. That was minimal information, but it was about
the only other source I know of besides the files I referred you to.

Regards,
Tom Ogilvy

Frank Arendt-Theilen

unread,

Jan 13, 2000, 3:00:00 AM1/13/00

to

Hallo Tom,
what a pity, but your help was great.
Thanks also to Bill, Patrick and Jim.
Regards,
Frank
_____________________________________________________

Am Thu, 13 Jan 2000 12:13:46 -0500, schrieb "Tom Ogilvy"

Bill Manville

unread,

Jan 13, 2000, 3:00:00 AM1/13/00

to

In article <85kkkg$1cl$1...@news.ml.com>, Patrick Molloy wrote:
> n the Excel VBE, open help and in the
> index tab, type 'Dialogs Collection Object' & hit Display. This opens the
> help sheet. At the very bottom is a link to the argument list that you're
> looking for.
>

That's a gem, Patrick. Thanks.