MrRhodes2004
12-28-2007, 01:16 PM
Below I have some quick code to open the Insert Function Dialog Box. But I would also like to programatically have it select the proper category and function. This I don't know how to do. What I have below is an example of what I would like to select. I just want to select the items. I do not want the code to 'press ok' so to speak but just select.
Sub OpenFunctionList()
'Opens "Insert Function" Dialog box
Application.CommandBars(1).Controls("Insert").Controls("Function...").Execute
'Select a Category ???
'code here to select "database"
'Select a function ???
'code here to select "dget"
End Sub
Thanks.
Sub OpenFunctionList()
'Opens "Insert Function" Dialog box
Application.CommandBars(1).Controls("Insert").Controls("Function...").Execute
'Select a Category ???
'code here to select "database"
'Select a function ???
'code here to select "dget"
End Sub
Thanks.