Formatting 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 in a list box
 

Roger,

Did you set up the List Boxes? I've used them before, but never set them
up. Could you help?

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

Formatting in a list box
 

I created the list box using the Data--Validation--Allow (selection) List
and then choosing the range of cells (or alternately using a named range).

"Iskus23" wrote:

Roger,

Did you set up the List Boxes? I've used them before, but never set them
up. Could you help?

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

Formatting in a list box
 

Thanks so much!

" wrote:

I created the list box using the Data--Validation--Allow (selection) List
and then choosing the range of cells (or alternately using a named range).

"Iskus23" wrote:

Roger,

Did you set up the List Boxes? I've used them before, but never set them
up. Could you help?

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