image pop ups

[mark901]

Is it possible to have an image pop up when i place my curser over a cell?

I have a list of nearly 1,000 dvds in a spreadsheet and have trouble remembering what they are and being able to see an image of the cover would help a great deal when trying to find a film to watch.

Thanks

 

[VoG]

You can insert a picture in a comment - see http://www.contextures.com/xlcomments02.html#Picture but this might get tedious to do 1000 of them

 

[Lewiy]

Welcome to the board!!

With 1000 items this could be a fairly tedious task, however……<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Copy and paste the image of each cover into the worksheet, with the image selected, change it’s name in the name box in the top left of the worksheet (the one that normally shows the current cell address). Probably easiest to name the image EXACTLY the same as the text that will be in the cell which denotes the movie.<o></o>
<o> </o>
This code will not show the image from hovering the mouse, but rather selecting the cell with the movie name in:<o></o>
<o> </o>

<o:p></o:p>

Private Sub Worksheet_SelectionChange(ByVal Target As Range)<o:p></o:p>
Dim sp As Shape, sh As Worksheet<o:p></o:p>
Set sh = ActiveSheet<o:p></o:p>
For Each sp In sh.Shapes<o:p></o:p>
    If sp.Name = Target.Value Then<o:p></o:p>
        sp.Visible = msoCTrue<o:p></o:p>
        Else: sp.Visible = msoFalse<o:p></o:p>
    End If<o:p></o:p>
Next sp<o:p></o:p>
End Sub

<o> </o>
Try it with a couple first to see if it works!

 

[mark901]

Lewiy

Sorry, i'm new to code.

How and where do i put the code in?

Thanks again

 

[VoG]

Lewiy seems to be offline.

Right click the sheet tab, select View Code and paste in the code. Then close the code window using the X.

 

[mark901]

Thanks.

I've put the code in and the images have just vanished off the worksheet?

 

[mark901]

VoG II

I have tried your suggested method and it works fine thanks

Is there a way to lock the images to the file so that if i move the worksheet and the image folder to another pc it will still find the images?