Hi Gord
The Bernie Deitrick is exactly what I am trying to do. When initials are
selected in one cell then the signature image appears in another. Multiple
times on one worksheet.
I tried using Bernie's code - but I am having two issues. One is that when
I try to have it look up the initials in merged cells and display the image
(signature) in merged cells it unmerges both sets of cells.
Secondly I can't get the image to display - only the name of the image.
any ideas or help would be greatly appreciated.
JB
"Gord Dibben" wrote:
Perhaps an approach other than an IF statement would do the job for you?
To have a picture show up when you select an item from a DV list or type in a
name see JE MCGimpsey's site.
http://www.mcgimpsey.com/excel/lookuppics.html
As written John's code allows for only one picture to be displayed.
Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for
adding pictures to selections.
Alows for more than one picture to be displayed.
http://www.contextures.on.ca/excelfiles.html#DataVal
DV0049 - ClipArt Selection
Gord Dibben MS Excel MVP
On Thu, 9 Aug 2007 05:58:06 -0700, Danopnu
wrote:
I would like to paste a picture in a single cell, but have only been able to
paste to the whole worksheet- any suggesstions? What I want to accomplish is
having a certain picture populate a cell if criteria is met (IF function)