Forum

Hover Over an Icon ...
 
Notifications
Clear all

Hover Over an Icon Popup

8 Posts
2 Users
0 Reactions
134 Views
(@paul_f)
Posts: 81
Estimable Member
Topic starter
 

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?

 
Posted : 14/09/2019 3:13 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Is it just to display a text popup or is it also clickable to run a macro etc?

 
Posted : 14/09/2019 11:12 pm
(@paul_f)
Posts: 81
Estimable Member
Topic starter
 

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.

 
Posted : 15/09/2019 1:30 am
(@sunnykow)
Posts: 1417
Noble Member
 

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? 

 
Posted : 15/09/2019 6:22 am
(@paul_f)
Posts: 81
Estimable Member
Topic starter
 

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?

 
Posted : 15/09/2019 1:06 pm
(@sunnykow)
Posts: 1417
Noble Member
 

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.

 
Posted : 15/09/2019 3:43 pm
(@paul_f)
Posts: 81
Estimable Member
Topic starter
 

This is interesting. If I add a lot of text it displays as one long line. What if want to have text wrap?

 
Posted : 15/09/2019 6:52 pm
(@sunnykow)
Posts: 1417
Noble Member
 

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

 
Posted : 16/09/2019 4:08 am
Share: