How to use the same picture in multiple cells?

N

Need Help in DC

To anyone who can help (please!),

I have an excel sheet that is being used to rate a number of questions
listed on the worksheet. I have a column that allows for the entry of a
numerical range (0-4), and what I need to do is have another column that
displays a small image depending on the value of the range column (e.g. a
rating of 4 shows an image of 4 stars in the next column over).

I've looked at the code provided in some previous messages about displaying
an image based on a cell value, but that only seems to work for one cell. I
need to use the same 5 images repeatedly on about 60 rows. Is there a way to
do this with VBA or some other excel magic?

Any help would be GREATLY appreciated.
 
D

Dave Peterson

How about a very easy alternative?

There are lots of symbols in different fonts that look like stars.

I put this in B1 and formatted that cell as Wingdings:
=REPT(CHAR(171),A1)

And it looked darn nice!
 
G

Gord Dibben

I like that Dave.

Gord

How about a very easy alternative?

There are lots of symbols in different fonts that look like stars.

I put this in B1 and formatted that cell as Wingdings:
=REPT(CHAR(171),A1)

And it looked darn nice!
Click to expand...

Gord Dibben MS Excel MVP
 
D

Dave Peterson

I changed singular to plural and didn't change "matters" to "matter".

From the anal-retentive grammarian (sigh).
 
G

Gord Dibben

Same like myself<g>

Gord

I changed singular to plural and didn't change "matters" to "matter".

From the anal-retentive grammarian (sigh).
Click to expand...

Gord Dibben MS Excel MVP
 
N

Need Help in DC

Thanks for the suggestion, but I was using stars only as an example. I've
drawn the image that I need to use, and the file size is relatively small so
they could either be embedded in the worksheet or called separately from the
same folder.

Any thoughts for that method?
 
Top