Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default List of the colors

Hi,

I would like to add a ComboBox on a UserForm with a list of colors. The list
will have the name of the oclor formated with his color or a box on the left
with the color.

Is it possible ?

Thank you for your help.

--
Patrick
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default List of the colors

If you want to color elements in the list of the combobox, then that isn't
supported.

You might look at this an see if it meets your needs:

http://www.j-walk.com/ss/excel/tips/tip49.htm

at John Walkenbach's site.

If it isn't exactly what you want, it should give you some ideas and the
code to get your started.

--
Regards,
Tom Ogilvy


"Patrick Fredin" wrote:

Hi,

I would like to add a ComboBox on a UserForm with a list of colors. The list
will have the name of the oclor formated with his color or a box on the left
with the color.

Is it possible ?

Thank you for your help.

--
Patrick

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default List of the colors

Thank you for your help.

--
Patrick


"Tom Ogilvy" wrote:

If you want to color elements in the list of the combobox, then that isn't
supported.

You might look at this an see if it meets your needs:

http://www.j-walk.com/ss/excel/tips/tip49.htm

at John Walkenbach's site.

If it isn't exactly what you want, it should give you some ideas and the
code to get your started.

--
Regards,
Tom Ogilvy


"Patrick Fredin" wrote:

Hi,

I would like to add a ComboBox on a UserForm with a list of colors. The list
will have the name of the oclor formated with his color or a box on the left
with the color.

Is it possible ?

Thank you for your help.

--
Patrick

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofilter list arrow colors Loris Excel Discussion (Misc queries) 4 January 29th 09 08:34 PM
Possible to change list text to 2 colors? RaY Excel Discussion (Misc queries) 3 August 14th 08 12:44 PM
drop-list with different colors for the same charachter coronettan Excel Worksheet Functions 4 November 28th 07 03:57 PM
Drop-down list with same character but in different colors coronettan Excel Worksheet Functions 0 November 26th 07 12:27 PM
WHere can I find a list of ColorIndex colors? Christiane[_12_] Excel Programming 3 April 28th 04 04:12 PM


All times are GMT +1. The time now is 07:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"