+ Reply to Thread
Results 1 to 6 of 6

Changing Backcolor in ActiveX Option Buttons

  1. #1
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Changing Backcolor in ActiveX Option Buttons

    Through much trial and error, I finally found a syntax for changing an option control's backcolor.

    Please Login or Register  to view this content.
    However, I want to apply this to about 50 optionbuttons on the form, and the following results in "Object doesn't support this property or method".

    Please Login or Register  to view this content.
    If I look at btn.Name, it is correctly referencing OptionButton1. Any suggestions?
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    Re: Changing Backcolor in ActiveX Option Buttons

    The problem you are having is on trying to assign the color. Try this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Changing Backcolor in ActiveX Option Buttons

    Thank you for the suggestion. It still gets the same error though. I also tried inserting .Interior.Backcolor, both with and without .Object, and all get the same results.

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,810

    Re: Changing Backcolor in ActiveX Option Buttons

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    Re: Changing Backcolor in ActiveX Option Buttons

    Quote Originally Posted by Mumps1 View Post
    Try:
    This is a good solution. I actually changed the Object to OLEObject and forgot to include that in my post.

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,810

    Re: Changing Backcolor in ActiveX Option Buttons

    @6StringJazzer: Thank you for the feedback.

+ 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. Activex frame hides option buttons - Xl 2007
    By Richard Buttrey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-18-2018, 01:32 PM
  2. [SOLVED] ActiveX Option Buttons disappeared
    By aaron_burr in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-10-2018, 02:42 PM
  3. activeX controls command buttons are moving arround and changing forms and sizes
    By mandura in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2015, 02:18 AM
  4. [SOLVED] Need to copy and paste activex buttons while changing the ranges they work with
    By navialivad in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2014, 04:08 PM
  5. option buttons changing names
    By BL1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2009, 04:30 PM
  6. [SOLVED] Changing BackColor on Command Buttons?
    By RBee in forum Excel General
    Replies: 0
    Last Post: 08-15-2006, 01:25 PM
  7. ActiveX Option Buttons all act as one group
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2005, 12:06 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