Hello all,
I have written a number of UDF's that return agregated data from a number of different sources. There is now a desire to provide drill-down capabilities for these values. I can successfully hyperlink them and send them to a custom macro as part of the UDF's. However, I have to parse the formula in the cell to derrive the appropriate parameters to fetch the underlying rows.
I would prefer to be able to have a custom object tied to the cell that I could query to retrieve the appropriate information, however I have not been able to determine how to attach a custom object to a cell.
Thanks in advance,
Tim
I have written a number of UDF's that return agregated data from a number of different sources. There is now a desire to provide drill-down capabilities for these values. I can successfully hyperlink them and send them to a custom macro as part of the UDF's. However, I have to parse the formula in the cell to derrive the appropriate parameters to fetch the underlying rows.
I would prefer to be able to have a custom object tied to the cell that I could query to retrieve the appropriate information, however I have not been able to determine how to attach a custom object to a cell.
Thanks in advance,
Tim