ExcelBanter - ListBox Drop Down Font Size

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - ListBox Drop Down Font Size (https://www.excelbanter.com/excel-worksheet-functions/203001-listbox-drop-down-font-size.html)

Phil B.

ListBox Drop Down Font Size

When developing a List Box using "Data/Validation" (Excel 2002), the drop
down text font is very small. How can you change this font size?
Thanks

Gord Dibben

ListBox Drop Down Font Size

With DV dropdowns you cannot change the font size.

See Debra Dalgleish's site for workarounds.

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

Gord Dibben MS Excel MVP

On Thu, 18 Sep 2008 07:00:01 -0700, Phil B.
wrote:

When developing a List Box using "Data/Validation" (Excel 2002), the drop
down text font is very small. How can you change this font size?
Thanks

Phil B.

ListBox Drop Down Font Size

Thanks. The Dalgleish workarouds will work for me.

"Gord Dibben" wrote:

With DV dropdowns you cannot change the font size.

See Debra Dalgleish's site for workarounds.

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

Gord Dibben MS Excel MVP

On Thu, 18 Sep 2008 07:00:01 -0700, Phil B.
wrote:

When developing a List Box using "Data/Validation" (Excel 2002), the drop
down text font is very small. How can you change this font size?
Thanks

All times are GMT +1. The time now is 07:46 AM.