Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
An AddIn for a custom function | Excel Discussion (Misc queries) | |||
How I know if a file is using a custom addin | Excel Discussion (Misc queries) | |||
How I know if a file is using a custom addin | Excel Worksheet Functions | |||
Custom Functions saved as addin | Excel Worksheet Functions | |||
Using custom functions within custom validation | Excel Discussion (Misc queries) |