Can you assign a value to a picture within excel?

[Guest]

Does Excel allow you to assign a value to a picture and vice versa?

I want to create a database that can create a visual report. The database
would be a table with specific percentages. However, when I need to generate
a report, those percentages need to be translated into pictures.

An example: A worker completes one task and not the other. The database
records a 1 to show the task is completed or 0 to show the task has not been
completed. When I need to print the worker's evaluation report, I want the
printout to show a happy face if the task was completed and an unhappy face
if it wasn't completed.

Suggestions?

Much appreciated!

 

[Guest]

What you can do is to put two picture on top of each other and bring the one
you want to the front. I did it yesterday for somebody. I used a
worksheet_change function. Based on a value in a pacrticular cell I moved
one of 3 pictures to the front. I used

ActiveSheet.Shapes("Picture 1").ShapeRange.ZOrder msoBringToFront

 

[Bernard Liengme]

Let A1:A10 hold the 1s and 0's
In A11 use =IF(SUM(A1:A10)>=7,CHAR(74),IF(SUM(A1:A10)>=5,CHAR(75),CHAR(76)))
Format the cell with Wingding font to get happy face, neutral face, frowning
face.
best wishes

 

[Don Guillett]

Use this idea to assign to a worksheet_change event and use if to toggle.

ActiveSheet.Shapes("picture 1").Visible = True