+ Reply to Thread
Results 1 to 4 of 4

Font Size in Command Button

  1. #1
    Jones E
    Guest

    Font Size in Command Button

    How do I change font size of the name on my command button?

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Response

    You can set this under the font option on the properties window (F4 in the VBA editor)
    Martin

  3. #3
    Jones E
    Guest

    Re: Font Size in Command Button

    thanks for the help

    "mrice" wrote:

    >
    > You can set this under the font option on the properties window (F4 in
    > the VBA editor)
    >
    >
    > --
    > mrice
    >
    > Research Scientist with many years of spreadsheet development experience
    > ------------------------------------------------------------------------
    > mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
    > View this thread: http://www.excelforum.com/showthread...hreadid=537313
    >
    >


  4. #4
    Registered User
    Join Date
    08-07-2011
    Location
    Estonia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Font Size in Command Button

    This procedure restores the buttons in the active worksheet

    Sub ButtonRestore()
    Dim shp As Shape
    For Each shp In ActiveWorkbook.ActiveSheet.Shapes
    If shp.Type = 12 Then
    shp.Height = shp.Height + 1
    shp.Height = shp.Height - 1
    End If
    Next shp
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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