Excel Function wizard category

Add-in Express™ Support Service
That's what is more important than anything else

Excel Function wizard category
Is it possible to change the selected category of the function wizard via code 
Michael Benowitz

Posts: 7
Joined: 2017-02-03
I'm using the code below to display the excel function wizard. Is it possible to set the selected category when I display the dialog using the code below?



Dim dialogs As Excel.Dialogs = Nothing
Dim insertFunctionDialog As Excel.Dialog = Nothing


dialogs = ExcelApp.Dialogs
insertFunctionDialog = dialogs(Excel.XlBuiltInDialog.xlDialogFunctionWizard)



If insertFunctionDialog IsNot Nothing Then Marshal.ReleaseComObject(insertFunctionDialog)
If dialogs IsNot Nothing Then Marshal.ReleaseComObject(dialogs)
End Try
Posted 24 Apr, 2017 10:18:47 Top
Andrei Smolin

Add-in Express team

Posts: 14461
Joined: 2006-05-11
Hello Michael,

The Excel object model doesn't provide a way to achieve this: at https://msdn.microsoft.com/en-us/library/office/bb211087(v=office.12).aspx, the xlDialogFunctionWizard dialog doesn't have an argument(s).

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 26 Apr, 2017 06:55:30 Top