Michael Benowitz
Posts: 32
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 |
|
Andrei Smolin
Add-in Express team
Posts: 18821
Joined: 2006-05-11
|
|