+ Reply to Thread
Results 1 to 8 of 8

Userform Checkbox Caption Font Size

  1. #1
    Registered User
    Join Date
    03-12-2017
    Location
    Wales, UK
    MS-Off Ver
    2016
    Posts
    11

    Userform Checkbox Caption Font Size

    Hi all,
    I'd like to throw something to you all that is puzzling me. I am writing a system for a friend of mine to help him run a window cleaning business. I have a code that populates a userform with values and checkboxes of customers on a defined round. The idea is that he can select which round to look at from a combobox which will allow the form to populate with the name, address and the works that are usually carried out, along with a textbox for the rate paid. All will populate from the worksheet. He can then check the boxes to generate an invoice for them (a later section of coding). This is a portion of the code:

    Please Login or Register  to view this content.
    It then carries on to add boxes for other items/rates and loops through the worksheet.

    My query is thus: Every time I run the code, it works perfectly, apart from the fact that the font size on the some lines of checkboxes is always bigger than the rest??? I'd guess maybe 10pts instead of 8? Its always the 2nd, 5th and 8th lines that are bigger. As I am defining the font size for the code that loops I would have thought this would be ok? What could cause one line to be different from the rest when it's created from the same code?
    Any ideas on what can be done?

    Thanks in advance!
    Dave

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Userform Checkbox Caption Font Size

    Reset them all with one code

    Please Login or Register  to view this content.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Registered User
    Join Date
    03-12-2017
    Location
    Wales, UK
    MS-Off Ver
    2016
    Posts
    11

    Re: Userform Checkbox Caption Font Size

    Quote Originally Posted by kev_ View Post
    Reset them all with one code

    Please Login or Register  to view this content.
    Thanks kev_, That was quite an obvious solution that I didn't think of trying, however after inputting the code it didn't work! Any other ideas?
    Thanks,
    Dave

  4. #4
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Userform Checkbox Caption Font Size

    Did you make it the last piece of code?
    Put the code behind a command button and run it separately

    If that does not work, perhaps they are not all checkboxes. Could try the same code without the condition
    i.e. the same loop but with this inside instead
    Please Login or Register  to view this content.

  5. #5
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Userform Checkbox Caption Font Size

    I would suggest that you stop using font size 8 if you want anyone to be able to read it. Try 10 or 12 for the important stuff.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  6. #6
    Registered User
    Join Date
    03-12-2017
    Location
    Wales, UK
    MS-Off Ver
    2016
    Posts
    11

    Re: Userform Checkbox Caption Font Size

    Quote Originally Posted by kev_ View Post
    Did you make it the last piece of code?
    Put the code behind a command button and run it separately

    If that does not work, perhaps they are not all checkboxes. Could try the same code without the condition
    i.e. the same loop but with this inside instead
    Please Login or Register  to view this content.
    Sorry for the delay, been out of action for a couple of days.
    I had it as the last line of code, and it didn't work. Just tried it on a command button and there isn't any change either.

  7. #7
    Registered User
    Join Date
    03-12-2017
    Location
    Wales, UK
    MS-Off Ver
    2016
    Posts
    11

    Re: Userform Checkbox Caption Font Size

    Thanks for the suggestion. The font size of 8 is perfectly readable in the context that I have it, so that's not a problem really. I'm just confused why it should do this seeing as the same code is being used to populate all of the userform?
    On further experimentation, the issue affects the 2nd, 5th, 8th and every third row from there.

  8. #8
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Userform Checkbox Caption Font Size

    The code you supplied would not appear to be the cause of your issue. So the problem is probably elsewhere.
    If you attach your workbook, I will investigate
    (click Reply/Go Advanced/look below for Manage Attachments etc)

+ 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 Caption Font
    By s_andrews in forum Excel General
    Replies: 5
    Last Post: 01-29-2020, 01:46 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. [SOLVED] Userform Checkbox caption
    By TimlmiT in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-03-2014, 10:28 AM
  4. [SOLVED] Userform to rename caption of Multipage as per Checkbox
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2014, 11:07 AM
  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. Change Checkbox Caption on Userform with Name in Variable
    By XLVBA in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2013, 04:43 PM
  7. Get UserForm checkbox caption and pass to another UserForm on click or mouse down
    By tulsaguy71 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-08-2013, 11:07 AM

Tags for this Thread

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