Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open "Function Argument Window" using a macro
Hi!
I developped an add-in containing a toolbox of functions to perform some calculations. However, I would like to create a kind of "easy-access" GUI for these and the way I found was to create a new menu item with sub-menu/items and the like. However, my toolbox is for functions, not macros, so I cannot simply run my function without any arguments when I select the item. Therefore, I would like to open a user form with the options for this function, just like the "Function Argument Window" that opens when we use the standard function button on the menu. (I'm talking about the menu with the arguments/tooltips) Is there any way to call this "Window Argument Form" directly and supply my function in argument and have it work just like if I clicked on the main function button? If I can avoid creating a user form I will as it's not really needed to have custom forms for my functions. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"page number" function as an argument | Excel Discussion (Misc queries) | |||
Pivot Table Creation Macro fails with Error #5 "Invalid procedure call or argument" | Excel Programming | |||
How to change the font of Display window of "Open File" | Excel Discussion (Misc queries) | |||
Use Macro to open "Find" window | Excel Programming | |||
Using a "File-Open"-Window in a Excel Macro? | Excel Programming |