View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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!