how to reference clipart in excel

20 pts.
Tags:
Clip Art
DropDownList
Microsoft 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."

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • BobBeechey
    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 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following