+ Reply to Thread
Results 1 to 2 of 2

Userform font size increases once initialized

  1. #1
    Registered User
    Join Date
    02-09-2013
    Location
    Alberta, CA
    MS-Off Ver
    O365
    Posts
    80

    Userform font size increases once initialized

    I have a userform which is taking the place of a loading screen. In the VBA screen it looks fine in regards to the font size and spacing.
    test 1.PNG

    Now depending on how large the form is, the font size inflates seemingly as it pleases.
    Test 2.PNG
    Test 3.PNG


    If I do not remove the title bar, it renders fine. As soon as I add the code to remove the title bar. I get the results posted above.
    I've used this in the past without issues so I have a feeling I am missing something obvious here.

    Code for the windowless userform (https://wellsr.com/vba/2017/excel/re...-userform-vba/)


    Please Login or Register  to view this content.
    All I have on the userform is the following
    Please Login or Register  to view this content.
    From the module its suppose to show right at the start so this is all that is before it.
    Please Login or Register  to view this content.


    The Userform properties have zoom set to 100 for all of the text boxes and background. AutoSize and WordWrap are set to false.

    Appreciate the feedback!

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Userform font size increases once initialized

    What is userform's Zoom setting?
    Add a Debug.Print Me.Zoom in the userform_initialize and one in userform_activate and see if there's a difference
    When removing the titlebar you have to take into account the the userform gets 24 points smaller in height
    Also, Miscrosoft has been updating the Office Software, quite some issue with 365 but who knows 2016 too, I don't know
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Userform Label property (Font size and bold)
    By niuyuer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2017, 03:43 PM
  2. Userform Command Button Caption (multiple lines & different font size)
    By VAer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2017, 05:08 PM
  3. Userform Checkbox Caption Font Size
    By didless in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-05-2017, 06:09 PM
  4. [SOLVED] Misbehaving font size on userform
    By chengafni in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-14-2017, 02:31 PM
  5. [SOLVED] Change font size of UserForm checkbox
    By PDBartlett in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-20-2014, 10:35 AM
  6. [SOLVED] Pb with textboxes font size in a UserForm
    By Jean-Pierre Bidon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2006, 01:55 PM
  7. [SOLVED] How does Userform get initialized by this?
    By RB Smissaert in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-12-2005, 01:50 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1