How do I increase the font size in a cell validation list?
Is it possible to increase the font size in a cell validation list? To make
it work now, I have to raise the % on the sheet view to where I can't see much of the sheet. Thanks in advance |
How do I increase the font size in a cell validation list?
Font size cannot be increased.
Debra Dalgleish has some suggestions for workaround. http://www.contextures.on.ca/xlDataVal08.html#Larger Gord Dibben MS Excel MVP On Wed, 9 Aug 2006 16:33:44 -0700, Brad Phelps <Brad wrote: Is it possible to increase the font size in a cell validation list? To make it work now, I have to raise the % on the sheet view to where I can't see much of the sheet. Thanks in advance |
How do I increase the font size in a cell validation list?
How about pasting this code into the appropriate sheet of the VB Editor. It
some code from Chip Pearson that zooms in when a particular cell is selected, in this case A2 Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$A$2" Then ActiveWindow.Zoom = 120 Else ActiveWindow.Zoom = 100 End If End Sub -- Hope this helps, MarkN "Brad Phelps" wrote: Is it possible to increase the font size in a cell validation list? To make it work now, I have to raise the % on the sheet view to where I can't see much of the sheet. Thanks in advance |
All times are GMT +1. The time now is 10:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com