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

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

"tsr1955" <tsr1955@discussions.microsoft.com> wrote in message 
news:24B2A336-3221-444E-B64A-D87753F497D7@microsoft.com...
>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 

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
-- 
Gary''s Student - gsnu200909


"tsr1955" wrote:

> 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