how do I increase drop list font and box size I created

[cdietz1]

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

 

[Gord Dibben]

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