Collection custom functions as asn addin
 

I have devised a some custom functions as required for my daily office work!
I think I should form a single addin file for the same.

Does an such addin needs to have such functions' codes be typed:
1. In the worksheet code; or
2. Behind the workbook code; or
3. Be inserted in a single module; or
4. Separate modules for each of the function should be devised and maintained?

Thanx in advance!

Collection custom functions as asn addin
 

Depending on how many there are, a single standard module should hold all of the
functions quite nicely.

A module can contain up to 64,000 lines of code, I believe.


Gord Dibben MS Excel MVP

On Sat, 29 Dec 2007 11:49:02 -0800, FARAZ QURESHI
wrote:

I have devised a some custom functions as required for my daily office work!
I think I should form a single addin file for the same.

Does an such addin needs to have such functions' codes be typed:
1. In the worksheet code; or
2. Behind the workbook code; or
3. Be inserted in a single module; or
4. Separate modules for each of the function should be devised and maintained?

Thanx in advance!

Collection custom functions as asn addin
 

I agree with Gord that the custom functions belong in General module(s).

But I think how many modules are up to you.

If the code for one function is extensive (lots of other functions/subs that get
called), you may want it in a separate module.

On the other hand, you may want to organize your routines by function. String
functions in one module. Numeric functions in another.

Heck, I've used dedicated modules for code that I've found on the
newsgroups--I'll put the link to the post (from groups.google.com) in a comment
at the top. Then I can find the original source if I need to.



FARAZ QURESHI wrote:

I have devised a some custom functions as required for my daily office work!
I think I should form a single addin file for the same.

Does an such addin needs to have such functions' codes be typed:
1. In the worksheet code; or
2. Behind the workbook code; or
3. Be inserted in a single module; or
4. Separate modules for each of the function should be devised and maintained?

Thanx in advance!

--

Dave Peterson