Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down List Formatting II | Excel Worksheet Functions | |||
Drop Down list formatting | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |