+ Reply to Thread
Results 1 to 4 of 4

Font Size Issue

  1. #1
    Registered User
    Join Date
    01-11-2011
    Location
    New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    25

    Font Size Issue

    Something I've tried to fathom for ages.. the attached Workbook
    has some labels on a Form. The Font is Tahoma Bold Size 6.

    Why does the size vary depending on it's Position (Top?) on the Form?
    How can I tell this has happened, without looking at it? Or correct it in code?

    I want to build controls onto the Frame at run-time. These vary, with their Top value dependent on the control aboves Top+ Height.

    This is all mucked up if Excel will not display the control at the right size.
    Any solutions most appreciated. Thanks.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-19-2019
    Location
    London
    MS-Off Ver
    2003-2016/2016 Mac
    Posts
    57

    Re: Font Size Issue

    Seems you have attached a black workbook.

  3. #3
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: Font Size Issue

    Hi AlexanderBB,

    The font for "Recordings" is set to MS Sans Serif not Tahoma.
    Composer and Publisher are both Tahoma Bold size 9.

    Regards

    peterrc

  4. #4
    Registered User
    Join Date
    01-11-2011
    Location
    New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Font Size Issue

    Hi Peter, the fonts were intended to all be the same, but doesn't really matter. Do you see "Publisher" being smaller than the other two ?
    If not, it must be a local problem (my graphics card ?).
    The top value for lblPub is 38. If I change that to 39 it displays correctly.
    So, assuming this isn't a local problem, my question is Why, and can I resolve it so each "top" value (as controls are added at run time) will display correctly?

    PS Are they size 9 for you? Should be 8.
    Last edited by AlexanderBB; 03-30-2019 at 05:29 PM.

+ 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. Font size changing issue - range from Excel to PowerPoint
    By Villalobos in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-13-2018, 04:13 PM
  2. [SOLVED] Email Font Size Issue with emails produced from Excel VBA
    By Tooley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2017, 11:13 AM
  3. Refer .font.name, .font.size, line.dashstyle to a cell instead of hard coding.
    By avarshav in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2016, 11:50 AM
  4. Replies: 15
    Last Post: 05-31-2012, 10:34 AM
  5. Replies: 3
    Last Post: 07-06-2011, 01:30 PM
  6. Replies: 5
    Last Post: 04-22-2011, 10:21 AM
  7. Dropdown list for font size, font type and number formats
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2005, 01:06 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