View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How to use the same picture in multiple cells?

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!

Need Help in DC wrote:

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.


--

Dave Peterson