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
130 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 51

Accepted Solution

by:
Rgonzo1971 earned 500 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

732 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