Results 1 to 4 of 4

Thread: Change the Font Size on the displayed LOV

  1. #1
    Seeker amyfb's Avatar
    Join Date
    Dec 2020
    Location
    Southeastern PA, USA
    Posts
    14
    Articles
    0
    Excel Version
    O365

    Change the Font Size on the displayed LOV



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,123
    Articles
    0
    Excel Version
    365
    Are you sure you don't have Shrink to fit on?:
    Click image for larger version. 

Name:	2022-05-19_150218.png 
Views:	6 
Size:	8.3 KB 
ID:	10948
    Last edited by p45cal; 2022-05-19 at 03:08 PM.

  3. #3
    Seeker amyfb's Avatar
    Join Date
    Dec 2020
    Location
    Southeastern PA, USA
    Posts
    14
    Articles
    0
    Excel Version
    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!


    Quote Originally Posted by p45cal View Post
    Are you sure you don't have Shrink to fit on?:
    Click image for larger version. 

Name:	2022-05-19_150218.png 
Views:	6 
Size:	8.3 KB 
ID:	10948

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,123
    Articles
    0
    Excel Version
    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).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •