Obviously it would be to use the same code on the other cells.

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.

What does that mean - select a column, but put a value in a cell? - what
cell - a column has 65536 cells. Be specific about what you are doing.

Post your code that you have described and exactly what range of cells you
want to work with and when you want the action to happen and how the action
will happen and perhaps someone can give you some advice.

How would be something like the cell changes based on a formula, the cell
changes because someone edits it, the cell changes because a macro changes
it.

--
Regards,
Tom Ogilvy



"M John" wrote:

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