Text in Drop Down Validation Boxes too small

Question

I have created a few validation lists. The text that appears in the 'Drop down' boxes are too small.

How could I increase the size of the text in these 'Drop down' boxes?

How could I make the 'Drop Down' boxes themselves larger, to accommodate the long rows that that are in the validated list?

Thanking You

crescent786

Answer 1

Thanks, I did try the code you sent me, but then the whole sheet zooms to about 100%. What I am looking for is a way to increase the size of the text in the drop down box with the validation lists, and hope fully increase the number of selections to over 8.

Thanks for your assistance

crescent786

Answer 2

Try use this vba code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

  Dim lZoom As Long

  Dim lZoomDV As Long

  Dim lDVType As Long

  lZoom = 100

  lZoomDV = 120

  lDVType = 0

  Application.EnableEvents = False

  On Error Resume Next

  lDVType = Target.Validation.Type

    On Error GoTo errHandler

    If lDVType <> 3 Then

      With ActiveWindow

        If .Zoom <> lZoom Then

          .Zoom = lZoom

        End If

      End With

    Else

      With ActiveWindow

        If .Zoom <> lZoomDV Then

          .Zoom = lZoomDV

        End If

      End With

    End If

exitHandler:

  Application.EnableEvents = True

  Exit Sub

errHandler:

  GoTo exitHandler

End Sub

more clearly you can read from this site http://www.contextures.com/xlDataVal08.html#Font

rasyha

Answer 3

The option to change the default text size in a data validation dropdown list is not available. Clickhere for detailed information.

Note: the given link is for Excel 2007; however the same information applies to Excel 2010.