View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default how to change font in form contollers

"Steven Jones" wrote:
does anyone know how to change the font in a drop down menu form control


Believe: "The font size in a data validation list can't be changed, nor can
its default list length, which has a maximum of eight rows."

Try Debra's page below:
http://www.contextures.com/xlDataVal08.html#Font

Scroll down about midway to this part:
Data Validation Font Size and List Length
(There's a workaround using programming described there)

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik
---