CODEWITHSUNDEEP
excelvba
TheJoeIaut
TheJoeIaut

Reputation: 1532

Excel Validation List Increase Font Size

Is is possible to increase the font size of an Excel Validation List via a macro?

If not is there an useful workaround?

Upvotes: 1

Views: 10271

Answers (2)

Kilroy
Kilroy

Reputation: 11

I needed a drop down list in column E to be larger to be readable. The following macro zooms to 100% if I click on any cell in column E past E4 and then goes back to my preferred zoom of 70% when I click anywhere else.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Column = 5 And (Target.Row >= 1 And Target.Row >= 5) Then
        ActiveWindow.Zoom = 100

    Else
        ActiveWindow.Zoom = 70

    End If
End Sub

Upvotes: 1

brettdj
brettdj

Reputation: 55672

Not by default

But yes there is a straightforward workaround. See Debra Dagleish's sample here at her Contextures site - a very thorough reference for Data Validation.

Upvotes: 0

Related Questions