Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another UDF Question
I have a UDF that refers to a range of data, for example, =My_UDF(A2:G45). I
would like to be able to relate a change in any cell in that range to the UDF that is using that range, so that I can update the object the UDF is controlling. I am trying to avoid using Application.Volatile because that is overkill, but I want to "trap" changes to cells that affect my UDF. For example, if I change the value of cell B24, then I would like to be able to go into the Worksheet_Change event, relate the change in B24 to the UDF that is referencing that cell (through the range A2:G45), and then do some other stuff related to that UDF. Question: Is there a way in VBA to determine what functions are referencing any particular cell on a worksheet? I would like to be able to generate a list of all the functions that use a particular cell. If my UDF uses a cell that changes, I want to do some selective updating of the object controlled by the UDF. Thanks, Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|