Auto start Function Wizard

[Steve D]

Good Morning,
I have created a user defined function and I have a toolbar button that
will insert the function into a cell. I would like for the toolbar button to
also open the function wizard so that the user can easily populate the range
and criteria for the function. Is there a way to do this?

 

[JNW]

If you already select the cell in your code then just add the following line:

Application.Dialogs(xlDialogFunctionWizard).Show

If you don't select the cell already you'll need to do that so that the
function wizard has a formula to reference.