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

A

ajo

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
 
T

Tom Ogilvy

You would have to use the selectionchange event to evaluate the formula and
take action based on its value.
 

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

Excel losing hyperlinks when I sort the worksheet 2
Running code when hyperlink clicked 6
check if hyperlink still works 3
Can UDF return a customized hyperlink? 3
Macro Unexpectedly calls a Function 4
Clearing Hyperlink formating from undefined # of cells in a column 3
Click on a hyperlink to hide or show a spreadsheet 4
Help- Simple function fails working with pasted values 4

Top