View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how do I increase drop list font and box size I created

If the dropdown was created using Data Validation.............Font size is set
at 8pt

Dropdown box height cannot be changed.

For workarounds like using a ComboBox and using Zoom see Debra Dalgleish's site
on DV Lists.

http://www.contextures.on.ca/tiptech.html


Gord Dibben MS Excel MVP

On Fri, 4 Apr 2008 11:36:02 -0700, cdietz1
wrote:

Font is small and you have to scroll through list due to box size