I am using Excel 2003.  I have a group of cells with a data validation 
"list".  That list contains 3 options -- check mark, "X", and "box" -- in 
Webdings.  When you click the drop down box to make a selection the options 
are in alpha-numeric characters (Arial font(?)) and not Webdings.  So my 
"check mark" becomes an "a" and my "X" becomes an "r".  

How can I get the drop down box to display the same font as the one in the 
list?

Both the drop down box cells and the "list" cells are formatted with the 
Webdings font.

Thanks for your help.

Short answer: You can't change font size/type/list length in data validation

See link for more info:
http://www.contextures.com/xlDataVal08.html#Font
-- 
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Doc77" wrote:

> I am using Excel 2003.  I have a group of cells with a data validation 
> "list".  That list contains 3 options -- check mark, "X", and "box" -- in 
> Webdings.  When you click the drop down box to make a selection the options 
> are in alpha-numeric characters (Arial font(?)) and not Webdings.  So my 
> "check mark" becomes an "a" and my "X" becomes an "r".  
> 
> How can I get the drop down box to display the same font as the one in the 
> list?
> 
> Both the drop down box cells and the "list" cells are formatted with the 
> Webdings font.
> 
> Thanks for your help.