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!
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!