+ Reply to Thread
Results 1 to 5 of 5

Change font size of UserForm checkbox

  1. #1
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Change font size of UserForm checkbox

    Hello

    I've inserted a checkbox into my userform and the caption is tiny.

    How do I change the size of the font?


    Thanks

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Change font size of UserForm checkbox

    With the checkbox selected, in the Properties window (f4 if not already visible), click in the box for Font property, then click the ellipsis (...) button and set the font how you want it.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Change font size of UserForm checkbox

    Hi

    Properties>>Font>>Choose what you like.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  4. #4
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Re: Change font size of UserForm checkbox

    Didn't see that tiny button! Thanks romperstomper!

  5. #5
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Change font size of UserForm checkbox

    When you are looking at the checkbox, on your userform in the visual basic editor, right click on the text (caption) and select properties. In the properties window find "Font" and click somewhere within that entry box. To the right of that box there will be a little square button. Click that button and a new box should pop up allowing you to change the size.

+ 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. Chang font size in a checkbox in excel 2010
    By bgilmore1202 in forum Excel General
    Replies: 1
    Last Post: 02-06-2013, 06:37 PM
  2. [SOLVED] Change default font and font size on COMMENTS in cells
    By Thistledown in forum Excel General
    Replies: 4
    Last Post: 11-23-2012, 09:26 AM
  3. How in VBA set Font Size for a checkbox?
    By jzurbo77 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-15-2009, 05:33 AM
  4. CheckBox Font Size
    By wz4np1 in forum Excel General
    Replies: 3
    Last Post: 08-21-2008, 06:21 AM

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