Home > IT Answers > Microsoft Windows > how to reference clipart in excel
Help

Question

  Asked: Jul 9 2008   12:11 AM GMT
  Asked by: Jedski25

how to reference clipart in excel


Microsoft Excel, Clip Art, DropDownList

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."

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jul 14 2008  5:01 PM GMT  by Schmidtw




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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Microsoft Windows and Development.

Looking for relevant Microsoft Windows Whitepapers? Visit the SearchEnterpriseDesktop.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

BobBeechey  |   Jul 17 2008  1:02AM GMT

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.