Function created in VBA not listed in worksheet existing functions.Pleae Help

[K]

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"

 

[Gord Dibben]

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

 

[K]

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

 

[Gord Dibben]

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