Formatting font in a list box
 

I have a range of 5 cells that have symbols (what our company uses to
indicate status) that are generated from a specific font set. When using
that font, a user presses alt+ 4 numbers from the number keypad to generate
the symbol. Lets say I name that range status. Then elsewhere, I generate a
list box that points to that range. When I click on the dropdown arrow, i
see the ascii code and not the symbol, but when I click the ascii character
the appropriate symbol is displayed. (Yes i have the entire sheet set to use
that font) How can I get the drop down to properly display the symbols so
that a user knows which one they are choosing?

Formatting font in a list box
 

If you use the combo box from the Control Toolbox, you can change the font.

Add the combo box, then right-click on it and choose Properties.
Click in the Font property, and click the ... button.
Choose the font with your special symbols, and click OK


wrote:
I have a range of 5 cells that have symbols (what our company uses to
indicate status) that are generated from a specific font set. When using
that font, a user presses alt+ 4 numbers from the number keypad to generate
the symbol. Lets say I name that range status. Then elsewhere, I generate a
list box that points to that range. When I click on the dropdown arrow, i
see the ascii code and not the symbol, but when I click the ascii character
the appropriate symbol is displayed. (Yes i have the entire sheet set to use
that font) How can I get the drop down to properly display the symbols so
that a user knows which one they are choosing?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html