Change the Font Size on the displayed LOV

amyfb

New member
Joined
Dec 18, 2020
Messages
24
Reaction score
0
Points
1
Location
Southeastern PA, USA
Excel Version(s)
O365
Hello!
I have a list of values that displays in a very tiny font size, smaller that the size of the values in the list itself.

I wrote a sub using Range(cell).Font.Size = 24 and this changes the selected value to the size 24, but the list itself continues to display in a very tiny zsize.

Changing the font size of the actual list supplying the LOV doesn't make a difference.

the only other suggestion I saw online was to change the font size of surrounding cells to the same value and then use the ctrl+scroll to zoom in.
and That does work, but, I wonder if there is a little more VBA that would settle it.

thanks!
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,152
Reaction score
2
Points
38
Excel Version(s)
365
Are you sure you don't have Shrink to fit on?:
2022-05-19_150218.png
 
Last edited:

amyfb

New member
Joined
Dec 18, 2020
Messages
24
Reaction score
0
Points
1
Location
Southeastern PA, USA
Excel Version(s)
O365
oh, you had me all excited there for a minute, but, when I looked, the shrink to fit box is unchecked. I took off word wrap as well, just in case that has some impact (it didn't).

hoping someone has the down low on this! THanks for looking and trying to help!


Are you sure you don't have Shrink to fit on?:
View attachment 10948
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,152
Reaction score
2
Points
38
Excel Version(s)
365
In which case, best attach a file where this is happening (only showing a few cells behaving this way, maybe the macro trying to adjust the font, but little else).
 
Top