excel vba - How to Return a result from a VBA Function - Stack ...

For non-object return types, you have to assign the value to the name of your function, like this: Public Function test() As Integer test = 1 End Function. Example ...

stackoverflow.com