View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteveG
 
Posts: n/a
Default How to increase font size in drop-down controll


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: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=506331