+ Reply to Thread
Results 1 to 9 of 9

How to change font size on an Active X controll button ("Command Button")

  1. #1
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Wink How to change font size on an Active X controll button ("Command Button")

    Is there a way to change font size on Active X control buttons (known as "Command Button")? Tried right-clicking on a button and then Properties, or CommandButton Object > Edit, or Format Control, but can't seem to find where to change it.

    Thanks
    You either quit or become really good at it. There are no other choices.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: How to change font size on an Active X controll button ("Command Button")

    Are you sure it's an ActiveX command button?

    If I add one to a sheet, right click it, select properties, and goto Font I can set the size/style/name of its font.
    If posting code please use code tags, see here.

  3. #3
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Re: How to change font size on an Active X controll button ("Command Button")

    Yes. If I do the same thing, the font size does not show up.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: How to change font size on an Active X controll button ("Command Button")

    Any chance you could upload a sample workbook?

    Click on GO ADVANCED, scroll down and click Manage Attachments.

  5. #5
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Re: How to change font size on an Active X controll button ("Command Button")

    Sure - here you go....
    Attached Files Attached Files

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: How to change font size on an Active X controll button ("Command Button")

    I can apply all sort of formatting to the command button.

    Are you having any other problems with the 'real' workbook?

  7. #7
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Re: How to change font size on an Active X controll button ("Command Button")

    Not sure by what you mean by 'real' workbook.... The only other thing I noticed is this:
    https://www.excelforum.com/excel-pro...no-reason.html

  8. #8
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: How to change font size on an Active X controll button ("Command Button")

    I was assuming you have a workbook with a bit more than a single command button and that was where you were experiencing the problem.

  9. #9
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Re: How to change font size on an Active X controll button ("Command Button")

    Oh, I see. The real one is very basic but has personal info on it, so can't really post it. I have the same issue in any new workbook that I start, though, so the issue is not limited to the one I am working on at the moment. If I insert a control button into any new workbook, there is not way to change the font 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. [SOLVED] "Pull" data from one closed workbood into active workbook with Command Button
    By klunker in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-08-2014, 02:29 AM
  2. Adding "Command Button" and "Messages Box" in VBA Macro
    By sanjeevkumarmc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2014, 07:21 AM
  3. Create a Command Button to "Save As" and "Close" an Excel Workbook
    By thedunna in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-26-2013, 05:38 PM
  4. Help with command button to Save/Lock/Email when the "completed" button is selected.
    By testing the water in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2013, 04:06 PM
  5. [SOLVED] Font Size in Command Button
    By Jones E in forum Excel General
    Replies: 3
    Last Post: 08-07-2011, 06:08 AM
  6. Colour change of the "Command Button"
    By Johann 12081 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-21-2009, 01:24 PM
  7. increase font size of command button name
    By sepandb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2008, 09:15 PM
  8. How to change a Command Button caption from "Enable" to "Disable"?
    By Infinity in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2007, 12:14 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