View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rahul Gupta Rahul Gupta is offline
external usenet poster
 
Posts: 21
Default 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