Dear All,

I have excel sheet with columns:

RefNo, Account, Project, Amount, Receipt

In the column "Receipt" I would like to insert image or link cell to image
file (it is jpeg format file). If I click cells e1, e2, e3 ... I want to
appear appropriated pictures. How can I do this?
How can I insert picture (in one cell) and how can I get it when I need to
see it in normal size?

Thank you in advance.
Lado

Select the cell where you want the picture
Turn on the macro recorder and then do Insert=Picture=From File and select
you file.

This should give you the basic code to start with.

--
Regards,
Tom Ogilvy



Kiknadze Lado wrote in message
...
Dear All,

I have excel sheet with columns:

RefNo, Account, Project, Amount, Receipt

In the column "Receipt" I would like to insert image or link cell to image
file (it is jpeg format file). If I click cells e1, e2, e3 ... I want to
appear appropriated pictures. How can I do this?
How can I insert picture (in one cell) and how can I get it when I need to
see it in normal size?

Thank you in advance.
Lado

Hi Tom,

Thank you for your answer. I did so as you told me but I could only to
insert picture in the Activesheet and not in the selected cell. Let me know
how to insert picture in the cell.

Best wishes,
Lado


"Tom Ogilvy" wrote in message
...
Select the cell where you want the picture
Turn on the macro recorder and then do Insert=Picture=From File and
select
you file.

This should give you the basic code to start with.

--
Regards,
Tom Ogilvy



Kiknadze Lado wrote in message
...
Dear All,

I have excel sheet with columns:

RefNo, Account, Project, Amount, Receipt

In the column "Receipt" I would like to insert image or link cell to
image
file (it is jpeg format file). If I click cells e1, e2, e3 ... I want to
appear appropriated pictures. How can I do this?
How can I insert picture (in one cell) and how can I get it when I need
to
see it in normal size?

Thank you in advance.
Lado

You can't insert a picture in a cell. A cell can only hold a number or a
text string. You can position the picture over the cell.

--
Regards,
Tom Ogilvy


Lado Kiknadze wrote in message
...
Hi Tom,

Thank you for your answer. I did so as you told me but I could only to
insert picture in the Activesheet and not in the selected cell. Let me
know
how to insert picture in the cell.

Best wishes,
Lado


"Tom Ogilvy" wrote in message
...
Select the cell where you want the picture
Turn on the macro recorder and then do Insert=Picture=From File and
select
you file.

This should give you the basic code to start with.

--
Regards,
Tom Ogilvy



Kiknadze Lado wrote in message
...
Dear All,

I have excel sheet with columns:

RefNo, Account, Project, Amount, Receipt

In the column "Receipt" I would like to insert image or link cell to
image
file (it is jpeg format file). If I click cells e1, e2, e3 ... I want
to
appear appropriated pictures. How can I do this?
How can I insert picture (in one cell) and how can I get it when I
need
to
see it in normal size?

Thank you in advance.
Lado