View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Lucas Swanson Lucas Swanson is offline
external usenet poster
 
Posts: 22
Default Formatting font in a list box

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?