Function wizard

336 views

Skip to first unread message

Holger

unread,

Oct 23, 2011, 4:45:47 PM10/23/11

to Excel-DNA

Is there a way to show the function wizard for a specific udf
programmatically.
For example from a menu item call.

Ron

unread,

Oct 24, 2011, 2:13:27 AM10/24/11

to Excel-DNA

Hi,

string previousFormula =
Application.ActiveCell.FormulaR1C1.ToString();
Application.ActiveCell.FormulaR1C1 = "=MyUdf()";
Application.ActiveCell.FunctionWizard();

if (!(bool)Application.ActiveCell.FunctionWizard())
{
Application.ActiveCell.FormulaR1C1 = previousFormula;
}

Regards,
Ron

Reply all

Reply to author

Forward

0 new messages