sum is represented by a picture?

[darrenkeith]

I just got off the phone with the advanced help for Microsoft Excel.
They have explained to me that there is no way of having a picture
(vlookup) appear instead of a number in a cell. I am a teacher and I
am attempting to display a picture instead of a letter for a grade when
a certain percentage is achieved. In other words, an A+ or 100% will
equal a smiley face or something. Somebody help me please.

 

[Jim Cone]

Here is one way, courtesy of John McGimpsey
http://www.mcgimpsey.com/excel/lookuppics.html
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



I just got off the phone with the advanced help for Microsoft Excel.
They have explained to me that there is no way of having a picture
(vlookup) appear instead of a number in a cell. I am a teacher and I
am attempting to display a picture instead of a letter for a grade when
a certain percentage is achieved. In other words, an A+ or 100% will
equal a smiley face or something. Somebody help me please.

 

[bobbo]

My suggestion would be to use one of the nonsensical fonts such as
wingdings or webdings. It may be possible to use some code and the
excel drawing layer to display clipart when a cell value is reached,
but that task may not be worth the novelty of the end product.

 

[acampbell012]

Not sure where you've been with this issue but, could you do something
like:

Sub mytest()

With ActiveCell
if .value = 100 then
.value = J
.Font.Name = "wingdings"
.Font.Size = 22
End With
End Sub

This converts a 100 to a happy face in the active cell.