View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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