20 pts.
 how to reference clipart in excel
Ok, what I want to do might not be possible, but I thought I would ask anyway. I have a simple drop-down box (data-validation) with "yes" and "no" options. Ideally, when someone chooses "yes" I would like a clipart to be entered into the cell. For instance, I would like a checkmark or a thumbs-up or something like that to replace the boring "yes."

Software/Hardware used:
ASKED: July 9, 2008  12:11 PM
UPDATED: July 17, 2008  1:02 AM

Answer Wiki:
As far as I know this cannot be done. You can place images over cells but not into them. There may be some intricate, involved, and round about way of doing this in VB but I am not sure.
Last Wiki Answer Submitted:  July 14, 2008  5:01 pm  by  Schmidtw   11,205 pts.
All Answer Wiki Contributors:  Schmidtw   11,205 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

There is one way, using Excel 2007, and that is to use conditional; formatting with an icon set. You are restricted to the shapes and colours built in but it could perform your task quite well.

 750 pts.