Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling functions in different modules
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)? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling functions in different modules
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)? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling functions in different modules
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)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling Add-In subroutines from other modules | Excel Programming | |||
calling modules | Excel Programming | |||
variable calling in different modules. | Excel Programming | |||
Calling certain functions within VBA | Excel Programming | |||
Calling VBA functions from a xll | Excel Programming |