Macro to automatically paste a pic based on a certain condition

[balayon]

Situation:
When a criteria is met: example: "cell A4 is less than 0", I would like
Excel to automatically paste a certain .jpg in an adjacent cell.

I've tried conditional formatting, however, it would only allow me to format
a cell or range of cells rather than to "add" something such as a picture.

Anyone know of a solution for this?
I currently am running Excel 2002.

Thank you!

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy


"balayon" wrote:

> Situation:
> When a criteria is met: example: "cell A4 is less than 0", I would like
> Excel to automatically paste a certain .jpg in an adjacent cell.
>
> I've tried conditional formatting, however, it would only allow me to format
> a cell or range of cells rather than to "add" something such as a picture.
>
> Anyone know of a solution for this?
> I currently am running Excel 2002.
>
> Thank you!

[balayon]

Thanks for the reply, Tom. However, I only need one picture for one
criteria. If a cell is 0 or less, then a frown would appear. Is this
possible without having to create a dB?

"Tom Ogilvy" wrote:

> http://www.mcgimpsey.com/excel/lookuppics.html
>
> --
> Regards,
> Tom Ogilvy
>
>
> "balayon" wrote:
>
> > Situation:
> > When a criteria is met: example: "cell A4 is less than 0", I would like
> > Excel to automatically paste a certain .jpg in an adjacent cell.
> >
> > I've tried conditional formatting, however, it would only allow me to format
> > a cell or range of cells rather than to "add" something such as a picture.
> >
> > Anyone know of a solution for this?
> > I currently am running Excel 2002.
> >
> > Thank you!

[Tom Ogilvy]

Sure just adapt the code at the site - it shows you the basic commands.

You would have to add code to delete the picture when you don't want it
there.

--
Regards,
Tom Ogilvy


"balayon" wrote:

> Thanks for the reply, Tom. However, I only need one picture for one
> criteria. If a cell is 0 or less, then a frown would appear. Is this
> possible without having to create a dB?
>
> "Tom Ogilvy" wrote:
>
> > http://www.mcgimpsey.com/excel/lookuppics.html
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "balayon" wrote:
> >
> > > Situation:
> > > When a criteria is met: example: "cell A4 is less than 0", I would like
> > > Excel to automatically paste a certain .jpg in an adjacent cell.
> > >
> > > I've tried conditional formatting, however, it would only allow me to format
> > > a cell or range of cells rather than to "add" something such as a picture.
> > >
> > > Anyone know of a solution for this?
> > > I currently am running Excel 2002.
> > >
> > > Thank you!