Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy the actual contents of a drop downlist | Excel Discussion (Misc queries) | |||
I HAVE A 175 NAME DROP DOWNLIST.IN CELL IS SMALL.HOW CAN I ZOOM | New Users to Excel | |||
Font Size in Data Validation Drop Down List | Excel Discussion (Misc queries) | |||
change font to validation drop lists | Excel Worksheet Functions | |||
Change font size in drop down validation lists | Excel Discussion (Misc queries) |