How to creat a dropdown list with format

N

Na$

hi,
I managed to create a dropdown list, but I'd like it to pick the format of
the original field. ie: font, collor, etc,etc... is this possible?
In my case, I have a list of numbers from 1 - 4 and each one has one color,
so I'd like when I pick a number it comes with its color, and it's coming
just the number...

thanks--
Malange, Angola
 
T

Tom Hutchins

I'm not sure that is possible with a dropdown list on a worksheet. Andy Pope
created VBA code (with a downloadable demo workbook) to color the items in a
dropdown list on a userform. Maybe the code is adaptable for a worksheet
control. Here is a link:
http://www.andypope.info/vba/colourdropdown.htm

Hope this helps,

Hutch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dropdown list determined by another dropdown list 5
Creating a dropdown list based on selection from a differernt drop 5
How to change contents of list dropdown 1
Can a Dropdown list change neighoring cells base of what is select 1
Creating a dropdown list within a column 4
Another Custom Format 2
Can a dropdown list option add color/time to a range? 1
How to use two drop-down list to fill data 2

Top