Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: [VBA] manually-select ActiveX commandbuttons & change font size
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular
    Join Date
    Jul 2015
    Posts
    357
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: [VBA] manually-select ActiveX commandbuttons & change font size

    attached a gif.

    https://imgur.com/a/9kudE4W
    Last edited by smallxyz; Aug 20th, 2019 at 11:17 PM.

  2. #12
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,870
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    7 Thread(s)

    Default Re: [VBA] manually-select ActiveX commandbuttons & change font size

    The whole of this thread has been about command buttons. It is no wonder you managed to befuddle me. The object in the gif whose text is made bigger is a combobox not a command button
    Thank you for the gif

  3. #13
    Board Regular Jaafar Tribak's Avatar
    Join Date
    Dec 2002
    Location
    Larache--Morocco
    Posts
    7,346
    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    3 Thread(s)

    Default Re: [VBA] manually-select ActiveX commandbuttons & change font size

    Quote Originally Posted by Yongle View Post
    I am intrigued - how are you making that work ?
    Active-X command button cannot be selected unless user switches to Design Mode but macros are disabled when in Design Mode
    Not necessarly true... You CAN actually run code and change the commandbutton attributes even in design mode .
    Office/Excel 2010 64Bits -- Win10 64Bits

    Common sense is not so common.


    http://photo-larache.blogspot.com/

  4. #14
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,870
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    7 Thread(s)

    Default Re: [VBA] manually-select ActiveX commandbuttons & change font size

    @Jaafar Tribak - agreed - I phrased that rather badly Thanks for the catch
    Last edited by Yongle; Aug 21st, 2019 at 03:29 AM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •