how to change font in form contollers

  • Thread starter Thread starter Steven Jones
  • Start date Start date
Cannot be done.

Use controls from the Control Toolbox instead.


Gord Dibben MS Excel MVP

On Sat, 12 Jul 2008 23:08:00 -0700, Steven Jones <Steven
 
Steven Jones said:
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
---
 
Back
Top