Incert a photo into a cell based on info in another cell

Hey,
I need to insert a photo into a cell (a cell that has been merged btw)
based on the information in a cell (i.e. A1). This cell (A1) uses list
validation and allows one to choose from a list of names. What I want
to do is put a photo into a cell (say B1) from a folder (say
C:\Photos\) based on the name that is selected in A1.

Make sense?

azidrane, have a look here and see if this will do what you want

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

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"azidrane" <[email protected]> wrote in message
news:[email protected]...
> Hey,
> I need to insert a photo into a cell (a cell that has been merged btw)
> based on the information in a cell (i.e. A1). This cell (A1) uses list
> validation and allows one to choose from a list of names. What I want
> to do is put a photo into a cell (say B1) from a folder (say
> C:\Photos\) based on the name that is selected in A1.
>
> Make sense?
>

Close Enough. Thanks Paul!

Your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"azidrane" <[email protected]> wrote in message
news:[email protected]...
> Close Enough. Thanks Paul!
>