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
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
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.