| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting font in a list box
No problem, I am glad that I could help.
Lucas "Bob Barnes" wrote: I work w/ Roger. This WORKS. We THANK you. Bob "Lucas Swanson" wrote: Since you mention a dropdown arrow, I am assuming that you mean a combo box, rather than a list box. First of all, make sure that you are using a combo box from the Control toolbox rather than from the Forms toolbox. Then you should be able to just right-click on the combo box & select "Properties," which should bring up the properties window. That window should have a section where you can select the font for the combo box. " 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 | |||
| Change Font/formatting for EXCEL Drop-Down List selector... | Excel Worksheet Functions | |||
| Formatting font | Excel Discussion (Misc queries) | |||
| Formatting font in a list box | Excel Discussion (Misc queries) | |||
| Drop Down List that has formatting of cell range Font ect. | Excel Discussion (Misc queries) | |||
| Dropdown list for font size, font type and number formats | Excel Programming | |||
Hybrid Mode
