Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto start Function Wizard
Good Morning,
I have created a user defined function and I have a toolbar button that will insert the function into a cell. I would like for the toolbar button to also open the function wizard so that the user can easily populate the range and criteria for the function. Is there a way to do this? -- Thank You, Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto start Function Wizard
If you already select the cell in your code then just add the following line:
Application.Dialogs(xlDialogFunctionWizard).Show If you don't select the cell already you'll need to do that so that the function wizard has a formula to reference. -- JNW "Steve D" wrote: Good Morning, I have created a user defined function and I have a toolbar button that will insert the function into a cell. I would like for the toolbar button to also open the function wizard so that the user can easily populate the range and criteria for the function. Is there a way to do this? -- Thank You, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office 2007 Configuration wizard runs every time I start anyApplication | Setting up and Configuration of Excel | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Office 2007 Configuration wizard runs every time I start anyApplication (word, excel, etc) | Setting up and Configuration of Excel | |||
Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
Can I start the text import wizard automatically? | Excel Programming |