LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default conditionally insert image

Hello,
I'm working on a rating system that will provide feed back based on one of
five images. The range of values is between 0 and 1.

0 - .2
..21 - .4
..41 - .6
..61 - 8
..81 - 1

I would like to be able to select a column of numbers and have a macro that
selects from one of five images to place in that cell.

Thanks to people on this discussion board, I've already got the code that
will insert an image based on an cell value (if A1 = 1, then insert an image)
as well as centering and sizing the image to the cell, but....I haven't yet
figured out (nor seen on the discussion board) how to assign a picture per
cell over a range of cells, based on the values in the cells.

Any help you can provide will be most appreciated.
Many thanks in advance,
MJohn
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I conditionally insert text into a cell on Excel 2007? RobertTFB New Users to Excel 1 August 7th 08 08:58 PM
Insert logo conditionally pkeegs Excel Discussion (Misc queries) 1 February 16th 07 02:15 AM
How do I conditionally insert an image (.bmp file)? Defoes Right Boot Excel Worksheet Functions 3 September 11th 06 07:29 AM
insert text conditionally and format John Sawyer Excel Discussion (Misc queries) 3 August 17th 05 06:51 PM
Insert comments conditionally - ajit Ajit Munj Excel Discussion (Misc queries) 3 June 10th 05 02:11 PM


All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"