software

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?

Roger,

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

quot; wrote:

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

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

quot;Iskus23quot; wrote:

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

Thanks so much!

quot; wrote:

gt; I created the list box using the Data--gt;Validation--gt;Allow (selection) List
gt; and then choosing the range of cells (or alternately using a named range).
gt;
gt; quot;Iskus23quot; wrote:
gt;
gt; gt; Roger,
gt; gt;
gt; gt; Did you set up the List Boxes? I've used them before, but never set them
gt; gt; up. Could you help?
gt; gt;
gt; gt; quot; wrote:
gt; gt;
gt; gt; gt; I have a range of 5 cells that have symbols (what our company uses to
gt; gt; gt; indicate status) that are generated from a specific font set. When using
gt; gt; gt; that font, a user presses alt 4 numbers from the number keypad to generate
gt; gt; gt; the symbol. Lets say I name that range status. Then elsewhere, I generate a
gt; gt; gt; list box that points to that range. When I click on the dropdown arrow, i
gt; gt; gt; see the ascii code and not the symbol, but when I click the ascii character
gt; gt; gt; the appropriate symbol is displayed. (Yes i have the entire sheet set to use
gt; gt; gt; that font) How can I get the drop down to properly display the symbols so
gt; gt; gt; that a user knows which one they are choosing?