How to return a result from a VBA function
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 usage: Dim i As Integer i = test() If the function returns an Object type, then you must use the Set keyword like this: Public Function … Read more