Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function created in VBA not listed in worksheet existing functions.Pleae Help
Hi all, I have created a functition called "SUMCOLOR" in vba and when
I checked in excel cell it was listed in existing excel functions. But when I saved that workbook in which I created that function as an excel adding and after installing that Addin when I tried using that function in other workbooks, the function was working but its not listed anymore in existing functions list. Please can any friend tell me that why is that. Basically i have created a function and i want to use it as Addin and i also want it to appear in excisting functions list so user will know that there is function called "SUMCOLOR" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function created in VBA not listed in worksheet existing functions. Pleae Help
If your add-in with the functions is properly loaded, your UDF's should show up
under User Defined category. That category will be at bottom of Insert Function list. Gord Dibben MS Excel MVP On Tue, 13 Jul 2010 08:53:22 -0700 (PDT), K wrote: Hi all, I have created a functition called "SUMCOLOR" in vba and when I checked in excel cell it was listed in existing excel functions. But when I saved that workbook in which I created that function as an excel adding and after installing that Addin when I tried using that function in other workbooks, the function was working but its not listed anymore in existing functions list. Please can any friend tell me that why is that. Basically i have created a function and i want to use it as Addin and i also want it to appear in excisting functions list so user will know that there is function called "SUMCOLOR" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function created in VBA not listed in worksheet existingfunctions. Pleae Help
Thanks for replying Gord. My Addin is properly loaded and my functions
do appear in User Defined category. My question was that in excel 2007 when user put something like "=S" in a cell then a list of all those functions appear which starts with "S" like (SUMPRODUCT, SUM etc…). I cant see my functions in that list. My functions were appearing before but they stoped appearing in functions list after when i saved that workbook as excel Addin. My function name is "SUMCOLOR" and basically i want this to be listed in other functions list when user put "=S" in the cell. Because nobody goto see functions in User defined category as they prefer that a functions list should popup as they type in cell. Please have you got any suggestions |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function created in VBA not listed in worksheet existing functions. Pleae Help
I cannot get these to appear in the dropdown unless they are in a module of the
active workbook. See my reply to your email. Perhaps someone in the programming group could help you. Post over there. Gord Dibben MS Excel MVP On Wed, 14 Jul 2010 00:58:52 -0700 (PDT), K wrote: Thanks for replying Gord. My Addin is properly loaded and my functions do appear in User Defined category. My question was that in excel 2007 when user put something like "=S" in a cell then a list of all those functions appear which starts with "S" like (SUMPRODUCT, SUM etc…). I cant see my functions in that list. My functions were appearing before but they stoped appearing in functions list after when i saved that workbook as excel Addin. My function name is "SUMCOLOR" and basically i want this to be listed in other functions list when user put "=S" in the cell. Because nobody goto see functions in User defined category as they prefer that a functions list should popup as they type in cell. Please have you got any suggestions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Created Worksheet Function Not Recalculating | Excel Discussion (Misc queries) | |||
Result in 3rd function from existing two functions | Excel Programming | |||
Edit created worksheet function | Excel Worksheet Functions | |||
Need to reference existing functions in a custom function: possibl | Excel Worksheet Functions | |||
Add-In Functions not listed in Automation | Excel Programming |