Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Can I add a tooltip text to a .jpg image that has been positioned in an Excel worksheet cell via the AddPicture method?

Posted on 2014-12-14
2
Medium Priority
?
151 Views
Last Modified: 2014-12-15
I add a .jpg graphic (sh)    to an excel sheet (wsIF)   at cells.row (rw) , cells.column (cl)

within an outer loop...
      With wsIF.Cells(rw, cl)
               Set sh = wsIF.Shapes.AddPicture("D:\bla\myPic.jpg", msoCTrue, msoTrue, .Left, .Top + 1, -1, -1)
               wsIF.Shapes(wsIF.Shapes.Count).Height = .Height
               wsIF.Shapes(wsIF.Shapes.Count).OnAction = "Item_Files_Icons_onAction" 'drive a macro
      End With
                wsIF_dat.Cells(activeItemFile_rowNo_wsItemFile, 1) = sh.Name 'to data

Is there a way of adding a tooltip property to the .jpg, so when the user points the cursor at the .jpg, some advisory text appears? I do not wish to add a comment to the cell in which the graphic appears, because the cell should be approx the same size as the graphic.

Thanks
Kelvin4
0
Comment
Question by:Kelvin4
2 Comments
 
LVL 54

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 40499758
Hi,

you could maybe use a dummy Hyperlink

wsIF.Hyperlinks.Add Anchor:=wsIF.Shapes(wsIF.Shapes.Count), Address:="", ScreenTip:="blabla"

Regards
0
 

Author Closing Comment

by:Kelvin4
ID: 40500535
Yes! It worked first time.
Thanks for your rapid responses and real help in 2014!

Kelvin
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question