Writing the Equivalent of a C++ Function?

[jazzscreamer]

Hi,
I'm still a newbie when it comes to VB and VBA. I have coded in C++ for years and I was wondering what the correct way is to write code that can be reused by calling it in other parts of the program. What I'm talking about is just like a function in C++, but I don't know the correct way to do this in VB. Thank you for any help.

Joel

 

[KenHigg]

pseudo:

print myfunction("Hello")
Hello World!

-----------------
myfunction(mytxt as string) as string
myfunction = mytxt & " World!"
end function


???
ken

 

[jazzscreamer]

Thanks, I knew it had to be simple.
Joel

 

[WayneRyan]

Joel,

To really be used in all of your forms, reports, queries, etc. put it in a
module (See the database tab).

Sample string function that adds a vbCrLf to end of argument:

Public Function SomeFunction(SomeArgument As String) As String
   SomeFunction = SomeArgument & vbCrLf
End Function

Wayne

 

[The_Doc_Man]

While you are at it, try to not depend on functions of type "void", as VBA tends to want a data type for its functions.