Pictures

Danopnu · External Since: Sep 20, 2006 Posts: 3

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)

Gord Dibben · External Since: Feb 23, 2004 Posts: 9179

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 <Danopnu.TakeThisOut@discussions.microsoft.com>
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)

Bob I · External Since: Dec 30, 2004 Posts: 531

Pictures don't go in cells.

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)

JB Bates · External Since: Sep 28, 2009 Posts: 4

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 <Danopnu RemoveThis @discussions.microsoft.com>
> 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)
>
>

Gord Dibben · External Since: Feb 23, 2004 Posts: 9179

First of all, Excel does not play nicely with merged cells.

I would get rid of those before I tried anything else.

Returning just the name of the picture is a problem I have never encountered
using Bernie's sample workbook as a base for a workbook.

Have you altered any of Bernie's sheet event code?

Gord

On Wed, 4 Nov 2009 08:31:01 -0800, JB Bates
<JBBates.RemoveThis@discussions.microsoft.com> wrote:

>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 <Danopnu.RemoveThis@discussions.microsoft.com>
>> 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)
>>
>>