Add tip text into shape and assign also macro

[jaryszek]

Hello,

i have shape added into worksheet and want to add tool tip like here and assign macro:

Screenshot_64.png

So i added hiperlink to cell B1 and after that i assigned macro :

Please Login or Register  to view this content.

but macro is not triggering (only link).
How can i do this ?

Jacek

[davesexcel]

You can use the worksheet_selectionchange event located in the worksheet module.

Please Login or Register  to view this content.

[jaryszek]

thanks!

Jacek