ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Function like =HYPERLINK(xxx) - Mouse interaction - "On Click Event" (https://www.excelbanter.com/excel-programming/352983-function-like-%3Dhyperlink-xxx-mouse-interaction-click-event.html)

[email protected]

Function like =HYPERLINK(xxx) - Mouse interaction - "On Click Event"
 
Hello,

I need to create a worksheet function in Excel, which will contain
event " MouseUp " to enable clicking on the cell, where the function
exist.
It's the same as function HYPERLINK, which displays a text on a cell,
but when the user clicks the text, the function takes parameters from
the definition, not only the cell value.

Please help!

Thanks in advance,
Ajo


Tom Ogilvy

Function like =HYPERLINK(xxx) - Mouse interaction - "On Click Event"
 
You would have to use the selectionchange event to evaluate the formula and
take action based on its value.

--
Regards,
Tom Ogilvy


wrote in message
ups.com...
Hello,

I need to create a worksheet function in Excel, which will contain
event " MouseUp " to enable clicking on the cell, where the function
exist.
It's the same as function HYPERLINK, which displays a text on a cell,
but when the user clicks the text, the function takes parameters from
the definition, not only the cell value.

Please help!

Thanks in advance,
Ajo





All times are GMT +1. The time now is 07:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com