Can you assign a value to a picture within excel?
 

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!

Can you assign a value to a picture within excel?
 

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!

Can you assign a value to a picture within excel?
 

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!

Can you assign a value to a picture within excel?
 

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!