Auto start Function Wizard
 

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?
--
Thank You,
Steve

Auto start Function Wizard
 

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.

--
JNW


"Steve D" wrote:

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?
--
Thank You,
Steve