vba function, return from function

Posted by Mike on Stack Overflow See other posts from Stack Overflow or by Mike
Published on 2010-05-06T14:11:00Z Indexed on 2010/05/06 14:18 UTC
Read the original article Hit count: 223

Filed under:
|
|

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?

© Stack Overflow or respective owner

Related posts about vba

Related posts about excel-vba