is it possible to create a pop-up tootip (or show another shape or textbox with help text) when hovering a button (created from a shape)
is it possible to create a pop-up tootip (or show another shape or textbox with help text) when hovering a button (created from a shape)
Hello wotadude,
Add a Hyperlink to the Shape using the right click menu. Send it to cell behind the shape. The Hyperlink has a tip text that is displayed when the mouse hovers on the shape.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Since the hyperlink takes precedence, that method doesn't work if you also want to run code, which I'm guessing OP needs to do.
The only way I know to have a tooltip as well as code assigned to buttons on a worksheet is to use actual button objects rather than an autoshapes, then use the controls' mouseMove event to set the visibility of associated labels.
Attached example from a recent project with 6 buttons (NB code contained in 3 places - wbkInfoTips, Sheet1 and hideInfo).
Would love to hear of any better solutions as mine's not exactly elegant.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks