View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default I've stumped College Prof. with this one!! NEED HELP!!

Probably because that isn't a capability of any of the comboboxes found in
Excel. (neither the control toolbox toolbar, forms toolbar, or data
validation list option).

As far as I know, there is no University offering a degree in Excel
proficiency, so stumping a College Prof on excel capabilities is not
necessarily significant <g.

You could write code to update an image control based on a selection in a
list or combobox.

--
Regards,
Tom Ogilvy

"Amanda" wrote in message
...
Does anyone out there know how to assign an image to a selection from a

drop
down box?

What I have created is a spreadsheet that contians 4 drop down boxes
horizontaly. Three of which are simple lists that result in formatted text

in
the specified cell, the fourth I am wanting to use a list drop down box,

but
instead of the text from the list appearing in the cell, I want an image

that
corresponds to the selected list text to appear in the specified cell.

Is this possible? If not, do you have a suggestion of what I might do to
render a similar result?

I have spoken with a few former Professors, self proclaimed Excel Gurus,
co-workers and we have not been able to figure this one out! I am truley
stumped!!! Any assistance is greatly appreciated!!!!!

--
Amanda Yazza
Golden Eagle of Arkansas, Inc. - Budweiser