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

[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.

 

[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.

 

[Bob Arnett]

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