I am trying to return a variable that I have given a value within a function.
example: VarX = 10 and then I put in "return VarX" and I keep getting a
compile error. Is there another way of returning the value in vba?

Function Example (Arg1 as Double) As Double
Example = Arg1*2
End Function

"WannaBeExceller" wrote in
message ...
I am trying to return a variable that I have given a value within a
function.
example: VarX = 10 and then I put in "return VarX" and I keep getting a
compile error. Is there another way of returning the value in vba?

Of course in my example Double should have been Long
Don't use Integers, use Longs (32 bits)

--
Kind regards,

Niek Otten

"WannaBeExceller" wrote in
message ...
I am trying to return a variable that I have given a value within a
function.
example: VarX = 10 and then I put in "return VarX" and I keep getting a
compile error. Is there another way of returning the value in vba?

Thank you very much guys. Worked like a charm!!

You don't need the Return key word

Public Function MyFunction () as integer
dim varX as integer

varX = 10

MyFunction = varX
End Function
--
HTH...

Jim Thomlinson


"WannaBeExceller" wrote:

I am trying to return a variable that I have given a value within a function.
example: VarX = 10 and then I put in "return VarX" and I keep getting a
compile error. Is there another way of returning the value in vba?