User defined functions aware of what cell they are placed in?

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi,

I would like to make a user defined function which needs to know in
what cell and what worksheet it is placed in. I will be using this UDF
in multiple cells on multiple worksheets. I originally just passed the
cell row and column as parameters to the UDF however this ended up
updating all worksheets and not just the one the UDF was on.

Is there any way to do this?
 
Option Explicit
function myfunct(something as somethingelse) as something

msgbox application.caller.address & vblf _
& application.caller.parent.name & vblf _
& application.caller.parent.parent.name

End function

(application.caller is what you're looking for)
 
Thanks!

Exactly what I've been looking for

Option Explicit
function myfunct(something as somethingelse) as something

msgbox application.caller.address & vblf _
& application.caller.parent.name & vblf _
& application.caller.parent.parent.name

End function

(application.caller is what you're looking for)
Click to expand...
 

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

RTD - zeros returned instead of correct data 1
Excel VBA 1
Excel behaves differently during macro record. 1
What can cause Excel to crash? 1
Where is User Defined FUnction 3
Adding ws information to cell in new wb & saving with ws name 7
XLM - some functions do nothing when used via defined name? 5
using defined name in UDF 7

Back
Top