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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Croucho - 15 Sep 2005 20:41 GMT

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

Reply to this Message

Mike - 16 Sep 2005 16:56 GMT

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

> Hey All,
>
[quoted text clipped - 4 lines]
> Thanks,
> Croucho

Reply to this Message

MDOTJR - 16 Sep 2005 18:09 GMT

only if you know VBS and can get creative with objects

Signature

MDOTJR

IT

Reply to this Message

Max - 17 Sep 2005 04:54 GMT

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
--

> Hey All,
>
[quoted text clipped - 4 lines]
> Thanks,
> Croucho

Reply to this Message

Max - 18 Sep 2005 00:32 GMT

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
--

Reply to this Message

Debra Dalgleish - 17 Sep 2005 13:42 GMT

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.

> Hey All,
>
[quoted text clipped - 4 lines]
> Thanks,
> Croucho

Signature

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

Reply to this Message