software

I have a work sheet with a drop down meny where the font is too small.
There are no properties option when right clicking the dropdown meny. (There
is the option of format controll, but this option does not give you the
opertunity to change the font.)

Thanks for any help with this problem.

If the worksheet is using a Data Validation list, the list takes on the
formatting of the font assigned to the cell the validation list is placed in.

If the drop-down list is using he combo box control from the Control
Toolbox, the font size is modified by placing the document in design mode
using the Control Tool Box Desigin Mode button, right clicking on the combo
box and selecting Properties. Locate the font property field, click to
activate the field and then click on the button with an ellipsis (...) to go
to the font menu.
--
Kevin Backmannquot;Iverquot; wrote:

gt; I have a work sheet with a drop down meny where the font is too small.
gt; There are no properties option when right clicking the dropdown meny. (There
gt; is the option of format controll, but this option does not give you the
gt; opertunity to change the font.)
gt;
gt; Thanks for any help with this problem.


Iver,

It sounds like you are using a Form and not a Control. Replace your
Form list box with a Control list box. When you right mouse click on
the Control, you will see a properties option. Select that and then
where it says font in the properties list, click on that and your
formatting options will appear. Select the larger font size etc...
This is also where you link the list range as well. Once you are done
formatting, exit the VBA design mode to activate your Control.

HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=506331