+ Reply to Thread
Results 1 to 4 of 4

Click oval option button to fill/unfill color, also change border color to match fill

  1. #1
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Click oval option button to fill/unfill color, also change border color to match fill

    Hi,
    I am looking for help on click an oval option button to fill color and change the border color to match the fill.

    If I click a different button, the last clicked button will change back to it's orginal "no fill and border color. At
    the same the newly clicked button will add fill color and change border color to match that fill.

    There may groups of oval option buttons; the example shows 2 groups.

    Hope someone can help.


    Thanks
    Last edited by Rocky2013; 02-07-2015 at 08:19 PM.

  2. #2
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474

    Re: Click oval option button to fill/unfill color, also change border color to match fill

    Have a look at the attached sample workbook. You'll notice that I used the "Title" in "Alt Text" (right-click the button > Format Shape > Alt Text > Title) to identify the group number for each button. Then I assigned the same macro to each button.

    Hope this helps!

  3. #3
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Re: Click oval option button to fill/unfill color, also change border color to match fill

    Hello,
    Your codes work 100% seamless. Thank you very much for the quick reply and solution.

    Thanks

  4. #4
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474

    Re: Click oval option button to fill/unfill color, also change border color to match fill

    You're very welcome! And thanks for your feedback!

    Cheers!

+ 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] Change a columns fill or border color based on current date
    By rcarlson67 in forum Excel General
    Replies: 2
    Last Post: 08-21-2014, 09:53 AM
  2. Change bar chart fill colors to match the color of a random cell
    By gwbe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-03-2014, 08:12 PM
  3. Replies: 0
    Last Post: 09-26-2012, 01:08 PM
  4. Replies: 3
    Last Post: 07-08-2010, 06:48 PM
  5. Change a cell's formatting, like 25% gray fill or L,R,T,B border color ???
    By BaLLZaCH in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2009, 05:19 PM

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