Symbols in Data Validation List


G

Guest

Hi there,
I want to know if there is a way to show the symbols (e.g. webdings,
wingdings) from a drop down list instead of it showing the text counterpart?
For instance, I have a drop down list that shows arrows. When you click on
the cell where the data validation was set up, the drop down only shows the
text counterpart of those symbols and not the arrows per se.
I changed the format of the cell so it would show the symbol once selected
and it's working fine. What I need is for the actual symbols to show from the
drop down so as not to confuse whomever is going to use the worksheet.
Your assistance is greatly appreciated.

Marie
 
Ad

Advertisements

N

Norman Jones

Hi Marie,

You cannot change the font of a data validation dropdown list. However, on
her web site, Debra Dalgleish demonstrates a workaround method for
displaying a combobox in data validation cells. The combobox font and size
properties can be set to suit your requirement.

See Debra's detailed instructions and sample file at:

http://www.contextures.com/xlDataVal10.html
 
Ad

Advertisements

G

Guest

Thanks Norman. I will try it and will advise if unsuccessful.

Marie
 

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

Top