Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I conditionally insert text into a cell on Excel 2007? | New Users to Excel | |||
Insert logo conditionally | Excel Discussion (Misc queries) | |||
How do I conditionally insert an image (.bmp file)? | Excel Worksheet Functions | |||
insert text conditionally and format | Excel Discussion (Misc queries) | |||
Insert comments conditionally - ajit | Excel Discussion (Misc queries) |