Font in validation drop-downlist
 

I have a validation drop-down list in a cell and since my
sheet is big, I've zoomed it to 50%. When I want to select
an Item from the list the font is so small that I can
hardly read it. Can I change the font in the drop-down
list?

Trond

Font in validation drop-downlist
 

Hi
you can't change the font of the valdiation listbox. But
see the following site for a workaround:
http://www.contextures.com/xlDataVal08.html#Larger

-----Original Message-----
I have a validation drop-down list in a cell and since my
sheet is big, I've zoomed it to 50%. When I want to
select
an Item from the list the font is so small that I can
hardly read it. Can I change the font in the drop-down
list?

Trond
.

Font in validation drop-downlist
 

You can't change the font size for a Data Validation dropdown list.
However, you can use programming to adjust the zoom setting when the
cell is selected. There's some sample code he

http://www.contextures.com/xlDataVal08.html#Larger

Trond wrote:
I have a validation drop-down list in a cell and since my
sheet is big, I've zoomed it to 50%. When I want to select
an Item from the list the font is so small that I can
hardly read it. Can I change the font in the drop-down
list?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html