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?

Thanks,

Mike

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

Try

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

insertFunctionDialog.Show()

Finally

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: 14138
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