multiple user-defined functions in add-in (2007)

B

Bob Arnett

Using Excel 2007: I'm just getting started in learning about UDFs and would
like to know if one would put multiple user-defined functions in a workbook
saved as an xlam file or is it limited to just one function per file.
 
D

Dave Peterson

You can have lots of UDF's in your workbook's project.

Depending on the complexity, you may find that it makes sense to put each UDF
into different modules of that same workbook's project.

Or even split the UDFs into different modules based on functionality.

I do like to make dedicated addins that are used with specific projects. But if
the UDF is kind of common and could be used in any workbook, they go into my
"general utilities" addin.
 
B

Bob Arnett

Thanks for the info and advice. There's a lot to learn in moving from Lotus
123 to Excel 2007.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UDF does not show up in Autocomplete 4
excel spreadsheet functions written in vba 1
Multiple User Defined Categories in Insert Function Form 2
How do I add a function category 1
User Defined Function being called by changes to an independent workbook 13
Managed Code UDF without Excel Services? 3
User Defined Functions 1
Combo box as an argument of an UDF 0

Top