Excel Question: Can I add images to a drop down list box?

Hey All,

I was wondering if anyone knew a way to have a drop down box that was
populated by images instead of straight text. Anyone out there have some
insight they wouldn't mind sharing?

Thanks,
Croucho

Pay some developers $100000 of dollars to come up with that excel addin.

"Croucho" wrote:

> Hey All,
>
> I was wondering if anyone knew a way to have a drop down box that was
> populated by images instead of straight text. Anyone out there have some
> insight they wouldn't mind sharing?
>
> Thanks,
> Croucho

A trawl through Google archives surfaced this post by Bob Phillips
where he provides the code to retrieve pictures
via data validation seelctions to a location near the DV cell:

http://tinyurl.com/degut

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Croucho" <[email protected]> wrote in message
news:[email protected]...
> Hey All,
>
> I was wondering if anyone knew a way to have a drop down box that was
> populated by images instead of straight text. Anyone out there have some
> insight they wouldn't mind sharing?
>
> Thanks,
> Croucho

Depending on what kind of pictures you need, one option is to create a
combo box from the control toolbox, and use the Wingdings or Webdings
font to display pictures.

Croucho wrote:
> Hey All,
>
> I was wondering if anyone knew a way to have a drop down box that was
> populated by images instead of straight text. Anyone out there have some
> insight they wouldn't mind sharing?
>
> Thanks,
> Croucho


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Here's a link to a demo file with Bob's sub implemented:
http://www.savefile.com/files/8341414
File: Select n Retrieve Pictures using DV.xls

(Still assuming, of course, that this is your underlying intent)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--