The xlDialogFunctionWizard shows that there are 30 arguments (Excel
2000). Does anyone know what these are? Designer help does not define
any arguments.

Or
Does anyone know how to access a the dialog for a specific function for
data input? For example, I have a menu button named "IRR", I'd like to
go directly to the IRR function data input form.

Thanks for any help.


--
bjoeylouie
------------------------------------------------------------------------
bjoeylouie's Profile: http://www.excelforum.com/member.php...o&userid=23819
View this thread: http://www.excelforum.com/showthread...hreadid=375286

Everything I have looked at indicate it has no arguments.


Try running this:

Sub Ac()
ActiveCell.Value = "=IRR(,)"
Application.Dialogs(xlDialogFunctionWizard).Show
End Sub


--
Regards,
Tom Ogilvy


"bjoeylouie" wrote
in message ...

The xlDialogFunctionWizard shows that there are 30 arguments (Excel
2000). Does anyone know what these are? Designer help does not define
any arguments.

Or
Does anyone know how to access a the dialog for a specific function for
data input? For example, I have a menu button named "IRR", I'd like to
go directly to the IRR function data input form.

Thanks for any help.


--
bjoeylouie
------------------------------------------------------------------------
bjoeylouie's Profile:
http://www.excelforum.com/member.php...o&userid=23819
View this thread: http://www.excelforum.com/showthread...hreadid=375286

Thank you!


--
bjoeylouie
------------------------------------------------------------------------
bjoeylouie's Profile: http://www.excelforum.com/member.php...o&userid=23819
View this thread: http://www.excelforum.com/showthread...hreadid=375286