.xla addin function

[msvec]

i have an addin that load automatically each time i open excel and it's full of subs that i use regularly and they work fine. i recently tried to add a function to one of the modules in the .xla file and when i'm in a spreadsheet, it won't work. if i move the function to a module specific to the sheet i'm in, no problems, but i would like to be able to include it in my .xla file.

any help in this area would be appreciated.

THANKS

 

[hennahairgel]

At the subroutine to the origianl sheet from which you created the add-in, and then saqve it as an add-in replacing the one with your current macros in it.

 

[hennahairgel]

At the subroutine to the origianl sheet from which you created the add-in, and then saqve it as an add-in replacing the one with your current macros in it.

 

[hennahairgel]

At the subroutine to the origianl sheet from which you created the add-in, and then saqve it as an add-in replacing the one with your current macros in it.

 

[msvec]

I'm not sure i fully understand what you're saying. the addin loads successfully each time i open excel and the code for the function appears correctly. Do you want me to overwrite my existing .xla with a new one that includes this function?

 

[dk]

It may be worth posting your function so that someone else can try it in one of their existing addins.

 

[msvec]

OK, here's the function:

Function countstr(cell_ref As Range, replace_val As String) As String

countstr = (Len(cell_ref) - Len(Replace(cell_ref.Value, replace_val, ""))) / Len(replace_val)

End Function

 

[dk]

OK,

I just pasted your function into an add-in (for this purpose I pasted it into the modmenu module of the HTML Maker add-in). The function worked fine.

When you say it doesn't work do you mean it isn't available if you choose Insert, Function. Then choose User Defined from the left hand list. Is the function countstr visible in the right hand list? If so, what doesn't work when you choose that, add the two arguments and click OK?

If the countstr function isn't available can you confirm that you don't have this:-

Option Private Module

anywhere in the module containing the function?