Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can the font in the Data Validation list be changed?
I have some single character wingdings that I have a named range defined for.
I am using the named range as my data validation range. I have formated the cells where the data validation is defined but the selection list shows the characters using the default font settings. I changed the |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can the font in the Data Validation list be changed?
You can't change the font in a data validation dropdown. If you can use
programming, there are instructions here for adding a combobox from which you can select one of the values from the data validation list. In the combobox, you can change the font to Wingdings: http://www.contextures.com/xlDataVal11.html Pat wrote: I have some single character wingdings that I have a named range defined for. I am using the named range as my data validation range. I have formated the cells where the data validation is defined but the selection list shows the characters using the default font settings. I changed the -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation - using a list from another workbook | Excel Discussion (Misc queries) | |||
Using a 'Select' (Data Validation) List? | Excel Worksheet Functions | |||
Data Validation and Blanks in List | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Data Validation - Dropdown List Not Appearing | Excel Discussion (Misc queries) |