+ Reply to Thread
Results 1 to 6 of 6

Change color of text in excel checkbox

  1. #1
    Registered User
    Join Date
    08-02-2017
    Location
    tokyo
    MS-Off Ver
    2013
    Posts
    6

    Change color of text in excel checkbox

    Hi,
    Does anyone have any idea how to change the color of text in excel checkbox?
    Right now the default color is black and I want to change it to blue.
    Using excel 2013. This seems doable in excel 2010, but i cant find a way to do it in 2013.
    Thanks
    Last edited by pinacoladasips; 08-25-2017 at 03:38 AM.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Change color of text in excel checkbox

    The caption text is the
    Please Login or Register  to view this content.
    This changes the text color
    Hope it helps you
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    08-02-2017
    Location
    tokyo
    MS-Off Ver
    2013
    Posts
    6

    Re: Change color of text in excel checkbox

    I'm not sure where to put this code. Please let me know where to put it.....

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Change color of text in excel checkbox

    Wherever you coded you checkbox, or else check the properties

  5. #5
    Registered User
    Join Date
    08-02-2017
    Location
    tokyo
    MS-Off Ver
    2013
    Posts
    6

    Re: Change color of text in excel checkbox

    I didnt code the checkbox, just inserted one from the developer tab in excel. Now i need to find a a way to change the color of the text; since i dont have much experience with macros, i dont know where to put the code. please let me know

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Change color of text in excel checkbox

    Like I said, check the properties for that checkbox and change the forecolor
    No macro neededCheckbox-Properties.PNG

+ 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] excel 2010, checkbox macro to change text upon doubleclick of cell?
    By fredderf81 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-13-2013, 02:35 AM
  2. [SOLVED] checkbox to change cell color
    By mezza89 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-05-2013, 03:03 PM
  3. Change graph color using a checkbox
    By q_awan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2012, 07:37 AM
  4. Excel 2007 : change color bij clicking checkbox ??
    By wartender in forum Excel General
    Replies: 1
    Last Post: 12-13-2011, 06:44 AM
  5. Dynamic Row Color Change w/ checkbox
    By BlueAcrux in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-23-2008, 09:39 AM
  6. How to make checkbox change cell color?
    By walkingthecow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2008, 12:19 PM
  7. Replies: 2
    Last Post: 01-27-2006, 08:15 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