Adding picrutes into cells

[George]

Hi.
I need a formula or code to add picture into cell.
lets say I type into cell a1: pict1 then automatically it will retreive
pict1.jpg from the folder that contains the picture without I need to type
the extention such as *.jpg
A1: PICT1 B1 : +A1 "will search for pict1 without the extention and
insert into cell B1"
Thank You
George.

 

[Gord Dibben]

George

Just to clear something up.

A picture cannot be inserted into a cell. It can lay on top of the cell.

For getting a picture to show up you need a Hyperlink formula or some code.

Maybe something for you at John McGimpsey's site.

http://www.mcgimpsey.com/excel/lookuppics.html


Gord Dibben MS Excel MVP

Hi.
I need a formula or code to add picture into cell.
lets say I type into cell a1: pict1 then automatically it will retreive
pict1.jpg from the folder that contains the picture without I need to type
the extention such as *.jpg
A1: PICT1 B1 : +A1 "will search for pict1 without the extention and
insert into cell B1"
Thank You
George.

Gord Dibben MS Excel MVP

 

[Gord Dibben]

George

Just to clear something up.

A picture cannot be inserted into a cell. It can lay on top of the cell.

For getting a picture to show up you need a Hyperlink formula or some code.

Maybe something for you at John McGimpsey's site.

http://www.mcgimpsey.com/excel/lookuppics.html


Gord Dibben MS Excel MVP

Hi.
I need a formula or code to add picture into cell.
lets say I type into cell a1: pict1 then automatically it will retreive
pict1.jpg from the folder that contains the picture without I need to type
the extention such as *.jpg
A1: PICT1 B1 : +A1 "will search for pict1 without the extention and
insert into cell B1"
Thank You
George.

Gord Dibben MS Excel MVP