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
135 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 52

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

628 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