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

You could change your drop-down to a combo-box control and then code the
value to the cell. Based on selection, show image, set location.

There might be another way. This is just a suggestion.

Cody


"Amanda" wrote:

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

I'm not exactly sure how to do that. Do you have time to explain?
--
Amanda Yazza
Golden Eagle of Arkansas, Inc. - Budweiser


"Cody" wrote:

You could change your drop-down to a combo-box control and then code the
value to the cell. Based on selection, show image, set location.

There might be another way. This is just a suggestion.

Cody


"Amanda" wrote:

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

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

Take a look he

http://www.mcgimpsey.com/excel/lookuppics.html

In article ,
Amanda wrote:

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,

Send me your email, and I will send you a workbook that shows how to do this using worksheet events.

To reply to me directly, take out the spaces and change the dot to . in my email address.

HTH,
Bernie
MS Excel MVP


"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