vba function, return from function

Question

I don't normally use VB, and even less vba for excel, but I'm writing a function inside a macro and seem to not understand even the basics of creating a function

For example

Public Function test() As Integer
    return 1
End Function

This gives a compile error.

This is profoundly stupid, but how do I make a function return an integer in vba?

Answer 1

You need to set the name of your function to the value like this:

Public Function test() As Integer
    test=1
End Function

Answer 2

VBA functions treat the function name itself as a sort of variable. So instead of using a "return" statement, you would just say:

test = 1

(Notice, though, that this does not break out of the function. Any code after this statement will also be executed. Thus, you can have many assignment statements that assign different values to test, and whatever the value is when you reach the end of the function will be the value returned.)