Resize the drop-down list font

[Mariya]

Hi guys,

I have a file in Excel, it is calculator. It is sent by my colleages from another office. In the drop-down menu all the options are with very small size, how can I change it? What is your advice.

Thank you in advance!

 

[herofox]

hello
Mariya ,i Didn't found any drop-down List in this Sheet !!!
which Cells You Mean?!!
and Please Change this post title ,to Resize the drop-down List font

 

[Mariya]

Hello Herofox,
Thank you for the title advice - I changed it.
The cells with drop-downs are lot but for instance from B2 to B8. The size when you choose is all right, but in the drop down is too small. I will attach the file again.
And the last but not least, it is Bulgarian language, it is not Russian ;-)

Thank you again for your support!

 

[herofox]

ok-by this Code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    On Error GoTo LZoom
    Dim xZoom As Long
    xZoom = 90
    If Target.Validation.Type = xlValidateList Then xZoom = 90
LZoom:
    ActiveWindow.Zoom = xZoom
End Sub

 

[Mariya]

Herofox,
Thanks a lot for your help! I wish to have your Excel skills.