Returning a value

[NewGuy100]

How do you return a value from a function or sub in VBA? The book I a
using is not real clear on this. Can you provide an example

 

[Bob Phillips]

As an example

Function myFunc(myVal)
myFunc = myVal * 2
End Function

Then you call like so

Msgbox myFunc(12)

Obviously the function should do more than that, but somewhere within it,
you have to pass the determined result back through the function name
(myFunc = myVal * 2) in my example. Usually, a variable is used within the
function to calculate that value and then pass it back through as the last
statement in the function.

The function can take multiple arguments, I only gave one in this simple
example.

You can also declare what type of variable the function returns, such as

Function myFunc(myVal) As Long

and also type the arguments so as to ensure data integrity in the caller,
such as

Function myFunc(myVal As Long) As Long

 

[Dave Peterson]

A simple example:

Option explicit
Function myFunction(myValue1 as double, myValue2 as double) as double
myfunction = myvalue1 * myvalue2
end function

Just assign the value you want returned to the function name.

 

[NewGuy100]

Thanks for the tip. It helped a lot. The book I am currently using doe
not help. It doesn't even mention functions or methods in the index

 

[Dave Peterson]

Maybe time for another book????

Debra Dalgleish has a list at her site:
http://www.contextures.com/xlbooks.html

John Walkenbach's is a nice one to start with. See if you can find them in your
local bookstore and you can choose what one you like best.