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!

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

"Big D" wrote:

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!

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Big D" <Big wrote in message
...
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!

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

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


--
Don Guillett
SalesAid Software

"Big D" <Big wrote in message
...
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!