View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Lado Kiknadze Lado Kiknadze is offline
external usenet poster
 
Posts: 1
Default how can I insert jpeg file in the cell?

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