This worked for me:
Sub Test()
Dim strTest As String
strTest = FunctionTest
Debug.Print strTest
End Sub
Function FunctionTest()
FunctionTest = "The Value"
End Function
Simple but it worked.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.