Calling a function in another module
 

How do I call function "TestFunction" that's located in Module1 when I'm
working in Module2?

Thanks

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

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

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

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