Function address from VB?

C

compound

Great day.

I have a question.

I'm trying to find out in VB from which cell my formula was called.

For example I have a user defined formula
public function MyFormula()
MyFormula = 10
end function

if somebody calls this function from sheet1 cell A1 (b
"=MyFunction()"). Is there a way for me to find out that in VB?

Thank you
 
Top