Declare the function in the code module as Public:
Public function DoSomething() as string
DoSomething = "You mean like this"
End Function
Then just call the function
msgbox DoSomething
"Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'."