Validation Lists

[jphall]

Hi

I have some cells with Data Validation Lists. Unfortunately the cells that I'm filling in have Windings as the font. It fills in the cell okay with the right character but the drop down list itself is in the main font (currently arial) so the contents don't match up with what they should do. Any ideas if its possible to have the right characters in the drop down list?

James

[Bjornar]

I don't know of any way to change the font of a drop down list from Data Validation, but you can use a Combo Box instead. You find this on the Control Toolbox toolbar. Right click on any toolbar if this toolbar is not visible, and activate it from the list. When you have created the Combo Box, you click om Properties (also on this toolbar). Then you can set the link to the cell you want the result, a link to the range with your drop down list, and you can set the correct font.