ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   xl Dialog Function Wizard Arguments (https://www.excelbanter.com/excel-programming/330534-xl-dialog-function-wizard-arguments.html)

bjoeylouie[_5_]

xl Dialog Function Wizard Arguments
 

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


Tom Ogilvy

xl Dialog Function Wizard Arguments
 
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




bjoeylouie[_6_]

xl Dialog Function Wizard Arguments
 

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



All times are GMT +1. The time now is 08:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com