![]() |
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 |
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 |
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