Function address from VB?

  • Thread starter Thread starter compound
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Application.Volatile Not Working Timely 2
To extract the number if there is niumeric in right most digits 4
VB Syntax 6
VBA function to define name in a worksheet 2
Relative VBA function 2
return the current row number for use in a formula 2
Excel Function 2
Excel VBA 1

Back
Top