+ Reply to Thread
Results 1 to 13 of 13

ActiveX Command Button Text Looks Bad

  1. #1
    Registered User
    Join Date
    01-11-2008
    Posts
    19

    ActiveX Command Button Text Looks Bad

    I have created an ActiveX command button and the text on the button looks crude. I know that is not very descriptive but I am unsure how to describe it. The text looks jagged and some letters are missing chunks of their letters. The font I have chosen is Calibri. If I create a Form Controls button I do not have this problem but I want the button to have a particular background color so I do not believe I can use a Form Controls button. I do not know why the other Calibri text on the worksheet looks fine while the ActiveX Calibri text does not. The attached image shows the two buttons with the top one being the ActiveX button while the bottom is a Forms button.

    Any way to fix this? Thanks,

    Shawn
    Attached Images Attached Images

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: ActiveX Command Button Text Looks Bad

    Hello brownsl,

    It doesn't appear that there is any difference between the fonts in your jpg image.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: ActiveX Command Button Text Looks Bad

    Hi Leith, thanks for that. I thought it as my eyes!
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    01-11-2008
    Posts
    19

    Re: ActiveX Command Button Text Looks Bad

    Hmm, it looks to me like on the ActiveX control that the top and bottom couple of rows of pixels are missing on the text. I think it is noticeable at the top of the "G" in "Gas" and at the bottom of the two e's in "Worksheet". I do not think I am crazy but maybe I am. I did notice that when I click the ActiveX button it then looks fine until the focus on the sheet goes away from the button.

    I have included an image of another button. Maybe it is more noticeable. In this image the top is the ActiveX button without it being clicked while the bottom is the same button when clicked. Once focus in the sheet goes away from the button it returns to looking like the top.


    Thanks for the help,

    Shawn
    Attached Images Attached Images

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: ActiveX Command Button Text Looks Bad

    Make the button taller?
    Entia non sunt multiplicanda sine necessitate

  6. #6
    Registered User
    Join Date
    01-11-2008
    Posts
    19

    Re: ActiveX Command Button Text Looks Bad

    I tried that and it did not help on those buttons. I am not sure how the graphics of the buttons work but it is almost like the text on the button is in something like a text box and this box is too small and truncates the text at the top and bottom. If this is true and I could make the text box bigger (not the button itself) then maybe that would solve it.

    Shawn

  7. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: ActiveX Command Button Text Looks Bad

    Resizing the button works fine for me.

  8. #8
    Registered User
    Join Date
    01-11-2008
    Posts
    19

    Re: ActiveX Command Button Text Looks Bad

    Here is yet another image. This is what the buttons look like if I make them bigger. It still looks like the top and bottom of the text is being truncated. However, looking at them closely it looks like it is more than just being truncated. The bottom text looks 'flatter' than the top text. This is noticeable in the 'o' and the 'e's.


    Shawn
    Attached Images Attached Images

  9. #9
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: ActiveX Command Button Text Looks Bad

    Picture looks fine to me. Post a workbook.

  10. #10
    Registered User
    Join Date
    01-11-2008
    Posts
    19

    Re: ActiveX Command Button Text Looks Bad

    Here is the workbook. Thanks for the help.

    Shawn
    Attached Files Attached Files

  11. #11
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: ActiveX Command Button Text Looks Bad

    I don't know how you got those buttons on the sheet, but they don't behave like like ActiveX buttons. I added one, and used the same captions and fonts -- they look about the same. It seems Excel doesn't do a magnificent job anti-aliasing fonts.

  12. #12
    Registered User
    Join Date
    01-11-2008
    Posts
    19

    Re: ActiveX Command Button Text Looks Bad

    I am using Excel 2007 and I inserted the ActiveX buttons using the Developer -> Insert -> ActiveX Controls -> Command Button. I am not sure what you mean by that they do not behave like ActiveX buttons? I had not inserted any code for the buttons yet.

    With respect to, the look of the text on the button, I guess I will just accept it and move on.

    Thanks again for the help,

    Shawn

  13. #13
    Registered User
    Join Date
    06-07-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: ActiveX Command Button Text Looks Bad

    i'm in the presence of clever people .... Thanks again

+ 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