return value from private vba function

[eHanSolo]

hi there,

can someone tell me how i can return a value computed using another function?

thank you!


so i roughly have:

sub example()

call myFunction(var1,var2)

'want to be able to use the result from myFunction here...

end sub

private function myFunction(var1 as string, var2 as integer) as double

'some code here that does some random thing
myFunction = dataThatIWant

exit function

end function

 

[PHV]

Replace this:
call myFunction(var1,var2)
with something like this:
Dim myVar As Double
myVar = myFunction(var1,var2)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Zathras]

[tt]
sub example()
Dim nSomeResult as Double

nSomeResult = myFunction(var1,var2)

'want to be able to use the result from myFunction here...

MsgBox nSomeResult

end sub
[/tt]

 

[eHanSolo]

cool.. thanks all!!!


e