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

only if you know VBS and can get creative with objects


--
MDOTJR

IT
------------------------------------------------------------------------
MDOTJR's Profile: http://www.excelforum.com/member.php...o&userid=27332
View this thread: http://www.excelforum.com/showthread...hreadid=468023

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" wrote in message
...
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
--