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

[Guest]

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

 

[Guest]

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

 

[MDOTJR]

only if you know VBS and can get creative with objects

 

[Max]

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

 

[Debra Dalgleish]

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.

 

[Max]

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)