Forms in Excel 2003

5 pts.
Tags:
DropDownList
Excel 2003
Excel macros
Microsoft Excel
I have created a form in 2003 Excel that has drop-down menu from a list file created on multiple worksheet within the document. This works fine. What I need to do is create a drop-down menu on a field that will not only bring up a list of title to choose from but also when a title is selected it will also bring up a picture of the project within the title. I will have a list of 10 titles with 10 different pictures associated with the title selected. Can someone help? Can this be done? Thanks in advance!
ASKED: July 5, 2008  12:59 AM
UPDATED: February 16, 2010  11:26 AM

Answer Wiki

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

As far as I know importing pictures INTO the actual cell cannot be done…at least not easily. You may want to check out some information on VB scripting in Excel to answer this one…but, like I said, putting a picture into a cell. You can place pictures OVER cells.

When you create a drop down menu, you are essentially making another column of cells, that just isn’t visible constantly. Because of this, they tend to carry the same functions as regular cells, only a bit more. With this in mind, I doubt their ability to contact graphics.

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
  • Samadhan
    how to use codeing in excel form save , exit , add commanf butan and type tax in form save to excel sheet plz halp me
    10 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