Using Excel 2000, I have created an add-in (VB_Custom_Functions.xla)
that contains four modules. When I call a function in one module (say
Module 4), how can I make that function call another function in a
different module (say Module 2)?

If they are Public functions they will be accessible to all modules in the
project. However, there is the potential for confusion if 2 functions in
different modules have the same name: if you need to resolve any conflicts
like this, use ModuleName.FunctionName

"CR" wrote:

Using Excel 2000, I have created an add-in (VB_Custom_Functions.xla)
that contains four modules. When I call a function in one module (say
Module 4), how can I make that function call another function in a
different module (say Module 2)?

From module 4, you can call the name of the function directly, OR, you can
preface it with Module2.NameofFunction (parameters)

http://HelpExcel.com

"CR" wrote:

Using Excel 2000, I have created an add-in (VB_Custom_Functions.xla)
that contains four modules. When I call a function in one module (say
Module 4), how can I make that function call another function in a
different module (say Module 2)?