how can i present a JPG in a window having cell with the path?

[tsr1955]

I build a catalog for coins collection with Excel. each row represents a coin
(record). in two cells (fields) i have a path to both sides of the coin
scanned as a JPG files in the specific directory. i would like the following
scenario: when i stand on a specific row (any cell), the relevant images are
presented in 2 big windows. when i move to another row, the image
automatically changes etc. i would like also to control the size of the
window. would appreciate your help, thanks, sam

 

[Harald Staff]

Hi Sam

See if this gets you started:

Insert an Image1 from the activex coltrols toolbox. Set its picturesizing
mode to zoom.

Worksheet code (rightclick sheet tab, "view code", paste this in:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim R As Long
R = Target(1).Row
Me.Image1.Picture = LoadPicture(Cells(R, "E").Value)
End Sub

where "E" is the column with the full picture path and name

HTH. Best wishes Harald

 

[Gary''s Student]

You can place a picture in a comment and then when you mouse-over the cell,
the picture will appear. See:

http://www.contextures.com/xlcomments02.html#Picture