How to Increase Font Size In Excel Drop-Down List Using VBA | Drop-Down List Font Too Small

Описание к видео How to Increase Font Size In Excel Drop-Down List Using VBA | Drop-Down List Font Too Small

Download the featured file here: https://www.bluepecantraining.com/wp-...

In this video I demonstrate how to increase the font size in an Excel drop-down list. Unfortunately Excel does not provide a way of changing the font size in a data validation drop-down list but you can automatically zoom in on the drop-down when selected.

Here's the code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

On Error GoTo SetZoom
Dim ZoomAmt As Integer
ZoomAmt = 100
If Target.Validation.Type = 3 Then ZoomAmt = 300

SetZoom:
ActiveWindow.Zoom = ZoomAmt
End Sub
------------------------

Комментарии

Информация по комментариям в разработке

Похожие видео