how to change font in form contollers
 

does anyone know how to change the font in a drop down menu form control

how to change font in form contollers
 

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
wrote:

does anyone know how to change the font in a drop down menu form control

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
---