+ Reply to Thread
Results 1 to 4 of 4

How to change Forecolor (Text) of activex optionbutton

  1. #1
    Forum Contributor
    Join Date
    12-02-2009
    Location
    Akron, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    208

    How to change Forecolor (Text) of activex optionbutton

    Working with excel vba 2016, I can't seemto get the correct syntax to change the text color of an ActiveX option button.
    These option buttons are in the worksheet.

    I have tried:
    Please Login or Register  to view this content.
    Also:
    Please Login or Register  to view this content.
    I want to distinguish one of the 4 option buttons, eith by changing it's text color or a background color (if that is possible).

    Thanks,
    Jeff
    Last edited by jrdnoland; 10-02-2020 at 05:48 AM.

  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,721

    Re: How to change Forecolor (Text) of activex optionbutton

    If these are ActiveX buttons then this:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    12-02-2009
    Location
    Akron, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    208

    Re: How to change Forecolor (Text) of activex optionbutton

    Quote Originally Posted by 6StringJazzer View Post
    If these are ActiveX buttons then this:

    Please Login or Register  to view this content.
    Fantastic! Thanks, 6StringJazzer

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

    Re: How to change Forecolor (Text) of activex optionbutton

    You're welcome and thanks for the rep!

+ 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 Optionbutton - Can I change a cell value based on button selected?
    By aquixano in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-15-2016, 08:23 PM
  2. Fast Loop for Forecolor change in Listview
    By BigDaddy01 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-01-2015, 06:02 PM
  3. [SOLVED] Change tab forecolor multipage UserForm
    By john55 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2014, 06:08 AM
  4. Change listItem forecolor based on criteria
    By ioncila in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-15-2012, 10:03 AM
  5. Excel 2007 : Change Macro Code with ActiveX Text Box
    By OrangeBoy in forum Excel General
    Replies: 0
    Last Post: 10-05-2011, 03:24 AM
  6. Macro to select/tick certain ActiveX OptionButton (radio button)
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2011, 08:40 AM
  7. Formula to change RGB to/from .Fill.Forecolor?
    By Air_Cooled_Nut in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2006, 01:12 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