Question

  Asked: Jul 5 2008   0:59 AM GMT
  Asked by: Mccuistionm


Forms in Excel 2003


Microsoft Excel, DropDownList, Excel macros, Excel 2003

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!

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


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

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


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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


Discuss This Answer


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