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

Thanks

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

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

Application.Run "Milestone" & testfunction()


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Barb Reinhardt" <(E-Mail Removed)> wrote in message
news:8C842059-B2B6-442A-8903-(E-Mail Removed)...
> 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

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