Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can I call a user defined function from a custom menu?
I have created an add-in (xla) that contains several functions. These functions work perfectly and show up under: Insert Function dialog box under the category: User Defined I am also able to create a custom menu by following the instructions on the following awesome site: http://www.ozgrid.com/VBA/custom-menus.htm What I am unable to do is to call the functions from the custom menu. Each UDF has its own module in the xla workbook and starts with Public Function <function name(serial As String) As Integer The OnAction line reads: ..OnAction = "<function name()" Error message that I get: The macro '<function name()' cannot be found Can you please help me out what I do wrong and tell me what the correct syntax for OnAction is? I appreciate your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Call user defined function in an add-in | Excel Programming | |||
Custom Format for User Defined Function | Excel Discussion (Misc queries) | |||
How to call a function of an user defined DLL from Excel? | Excel Programming | |||
Excel "Insert Formula" dialog always call my user defined function | Excel Programming | |||
Call GoalSeek from a user-defined-function | Excel Programming |