ExcelCOM_UDF and Hyperlinks, How do I know which hyperlink is clicked?

[allen9158]

There is a function in the UDF to add hyperlink. My problem is that I want to trace which hyperlink is clicked in order to get the data from that cloum, after that i will use this data to do some other task

[ahha]

There is a function to add a hyperlink:

_ExcelHyperlinkInsert($oExcel, $sLinkText, $sAddress, $sScreenTip, $sRangeOrRow, $iColumn = 1)