I am including a drop-down list in an Excel workbook. When the item is
selected from the list it is entered into the workbook at the correct font
size i.e. 20 point. However in the drop-down list it is illegible as it is
only about 5 point. Does anyone know how to change the font size in the
drop-down list

Thanks in advance

Bob

If drop-down list is from Data Validation you cannot change the point size,
which is 8 pts.

For workarounds see Debra Dalgleish's site.

http://www.contextures.on.ca/xlDataVal08.html#Font


Gord Dibben Excel MVP

On Wed, 28 Sep 2005 14:37:03 -0700, "Bob Clarke" <Bob
wrote:

I am including a drop-down list in an Excel workbook. When the item is
selected from the list it is entered into the workbook at the correct font
size i.e. 20 point. However in the drop-down list it is illegible as it is
only about 5 point. Does anyone know how to change the font size in the
drop-down list

Thanks in advance