How to Increase Font Size In Excel Drop-Down List Using VBA | Drop-Down List Font Too Small
HTML-код
- Опубликовано: 5 сен 2024
- Download the featured file here: www.bluepecant...
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
------------------------
I downloaded the file, ran a test. The cell containg the drop-down list zoomed as expected, but the values in the list were not zoomed.
It doesn't work for me either. I had a code that was similar in function to this one and it used to actually make the menu choices bigger. I had had a screenshot one time doing a comparison. Then we upgraded to Excel 365 and I just recently noticed it doesn't work anymore. It zooms the cell, but the drop-down menu's font is still the same whether the code is there or absent. Do you have Excel 365 as well?
Thanks for help! Great!
Thank you for this. Is there a way to combine this code and your select Multiple Items From Drop Down List together?
Any help is appreciated. Thanks!
Thank you! You solved my problem.
Thanks man! Big help
cool man, thank you !!!!
Happy to help!
Superuseful 👌
What's the meaning of Target.Validation.Type = 3??
It doesn't matter if you type Yes or No. The behavior is the same, it's a toggle behavior.
Good morning sir,
It's work good .👍