Macro to automatically paste a pic based on a certain condition
 

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!

Macro to automatically paste a pic based on a certain condition
 

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!

Macro to automatically paste a pic based on a certain conditio
 

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!

Macro to automatically paste a pic based on a certain conditio
 

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!