| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling a function in another module
How do I call function "TestFunction" that's located in Module1 when I'm
working in Module2? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calling a function in another module
Use:
Call Module1.TestFunction "Barb Reinhardt" wrote: How do I call function "TestFunction" that's located in Module1 when I'm working in Module2? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calling a function in another module
I want to concatenate the result of the test function with "Milestone"
Right now, I have "Milestone" & testfunction() but it doesn't work with the call part. Suggestions? "Rahul Gupta" wrote: Use: Call Module1.TestFunction "Barb Reinhardt" wrote: How do I call function "TestFunction" that's located in Module1 when I'm working in Module2? Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calling a function in another module
write Testfunction as
Function Testfunction(ByVal Data_to_be_concatenate As DataType) As ReturnType for example: Function TestFunction(ByVal s as String) As String Hope this will help. Regards, Rahul "Barb Reinhardt" wrote: I want to concatenate the result of the test function with "Milestone" Right now, I have "Milestone" & testfunction() but it doesn't work with the call part. Suggestions? "Rahul Gupta" wrote: Use: Call Module1.TestFunction "Barb Reinhardt" wrote: How do I call function "TestFunction" that's located in Module1 when I'm working in Module2? Thanks |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calling a function in another module
Application.Run "Milestone" & testfunction()
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Barb Reinhardt" wrote in message ... I want to concatenate the result of the test function with "Milestone" Right now, I have "Milestone" & testfunction() but it doesn't work with the call part. Suggestions? "Rahul Gupta" wrote: Use: Call Module1.TestFunction "Barb Reinhardt" wrote: How do I call function "TestFunction" that's located in Module1 when I'm working in Module2? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calling a module | Excel Discussion (Misc queries) | |||
| Calling a Macro from module | Excel Programming | |||
| Calling worksheet module from other module. | Excel Programming | |||
| Calling VBA function that is in another module | Excel Programming | |||
| Calling a module function from a class method | Excel Programming | |||
Hybrid Mode
