Change the Font Size on the displayed LOV

[amyfb]

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]

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

[amyfb]

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?:

[p45cal]

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).