Pop up messages when hovering over a picture

[Buddha532]

I am trying to put together a visual training document in excel 2010. I would like to know if there is a way to mouse over the picture to have a pop up text box appear.

Thanks!

 

[otvasilescu]

Well you can merge all of the cells underneath the picture and insert a comment to that big merged cell. Would that work for you?

 

[MickG]

Add Hyperlink , "Place In this Document" and "ScreenTip, Text"

 

[Buddha532]

Add Hyperlink , "Place In this Document" and "ScreenTip, Text"

Let's start with the original picture, i am using that as the background. I then take a copy of the original picture and crop out parts of that picture and paste it over the original picture. I realize every time i produce a snip-it of the picture it gets a new name in the Name Box. I was hoping there was some kind of code referencing the name of the picture to create a pop up text when the user hovers over parts of the image.

 

[MickG]

How to add "ScreenText" with code :-
Create Basic Code Module and Place the code below into it.

Sub ScreenText()
   ActiveSheet.Shapes.Range(Array(Application.Caller)).Select
   ActiveSheet.Hyperlinks.Add Anchor:=Selection.ShapeRange.Item(1), Address:="", ScreenTip:=Application.Caller
End Sub

Close Code window

Select picture on sheet for "ScreenText"
Right click the Picture, select "Assign Macro"
Macro Dialog Box Appears
From the Macro list Select "ScreenText".
Click "OK"

Now Click the Picture to Run code
Hover Curser over picture to see "ScreenText":- picture Name