Log In
Register
Home
July 7, 2016
Offline
Would it be possible to hover your pointer over an icon or symbol and have an information balloon or text pop up? Could this be done with VBA?
VIP
Trusted Members
June 25, 2016
Offline
Is it just to display a text popup or is it also clickable to run a macro etc?
July 7, 2016
Offline
Just to display a text popup for informational purposes. The alternative is to use Data Validation, just using the Input Message tab. The user clicks the cell and the message pops up. It works better than inserting a New Note. But I think even better would be a hover feature which might be more flexible about size and number of characters.
VIP
Trusted Members
June 25, 2016
Offline
Is the icon/symbol an image/picture? I was thinking about using hyperlink as it contains captions. The hyperlink for the image could be disabled (with VBA) but the caption will still show when the mouse hovers over the image/picture. Is it acceptable?
July 7, 2016
Offline
I experimented with this approach, attached. You can't hyperlink an image (that I know of) but you can hyperlink a cell with a ScreenTip. The hyperlink destination refers to the same cell so it doesn't go anywhere even if you click it. is this what you had in mind?
VIP
Trusted Members
June 25, 2016
Offline
You can hyperlink an image. Refer my attachment.
You will need to run the attached macro for each image.
Just change the image's name and the tool tip.
Hope this helps.
July 7, 2016
Offline
This is interesting. If I add a lot of text it displays as one long line. What if want to have text wrap?
VIP
Trusted Members
June 25, 2016
Offline
You can try adding a carriage return like this to the code.
"Message at row 1" & vbcr & "Message at row 2" & vbcr & "Message at row 3" etc
No idea what is the maximum length allowed.
Good luck
1 Guest(s)
