Retrieving Macro Values

[jdresie]

This question probably has an easy answer, but I can't find it in the help.

I have a Visual Basic macro function that does some non-standard
calculations. I have it written as a function so I could got into any cell and
type its name and inputs (ie. =cheat(...)). However, there is only one value
I want out of the macro, and I don't know how to get that value as the
result in the cell.

I think the mathematics etc. are okay in the macro, but I don't know the
command that specifies the out put! Please help

Thanks
J

 

[mdusoe]

If your function is defined as:

Function Cheat(x as integer, y as integer)

Then you set the function name equal to the value you want. So, for example, if you want to return the value of z, you would use:

Cheat = z
End Function

Does this help?

Mike.

 

[Greg Truby]

You just set the function's value to whatever you're returning.

Function Cheat(varInput as Variant) as Double
    ' math, math, math
    Cheat = (whatever you came up with)
End Function

 

[jdresie]

That is exactly what I was looking for.

Thanks guys, I figured it was something that simple.

J