+ Reply to Thread
Results 1 to 4 of 4

Change background color an activeX check box beyond the standard palette

Hybrid View

  1. #1
    Registered User
    Join Date
    06-28-2010
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Change background color an activeX check box beyond the standard palette

    Hi

    I searched high and low for this, I was hoping someone can help.

    I have an activeX check box named: CheckBox 1

    I want thet back color to be RGB(22, 54, 92)

    Please let me know if you have any ideas.

    Any help would be greatly appreaciated.

    Thank you!

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Change background color an activeX check box beyond the standard palette

    CheckBox1.BackColor = RGB(22, 54, 92)

  3. #3
    Registered User
    Join Date
    06-28-2010
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Change background color an activeX check box beyond the standard palette

    Thank you. May I ask where this line of code belongs? Thank you!

  4. #4
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Change background color an activeX check box beyond the standard palette

    Depends when do you want the color to be changed?
    If you just want it one time, go to the properties of the checkbox and change the back color value to &H005C3616&.



    &H005C3616&

    The segments of the code are arranged as BGR instead of RGB, and in hexadecimal.

    To convert decimal to hexadecimal, you can use a formula in Excel, DEC2HEX.

    RGB(22, 54, 92)
    
    Type in any cell ->     =DEC2HEX(92)
    You would get ->       5C
    
    &H005C
    
    
    Type in any cell ->     =DEC2HEX(54)
    You would get ->       36
    
    &H005C36
    
    
    Type in any cell ->     =DEC2HEX(22)
    You would get ->       16
    
    &H005C3616&
    And paste/type that into the back color property.

+ 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. Replies: 5
    Last Post: 05-22-2013, 10:24 PM
  2. [SOLVED] Check box to change background color when checked
    By mrjinx007 in forum Excel General
    Replies: 10
    Last Post: 11-02-2012, 07:27 PM
  3. [SOLVED] Macro to change all cells with a certain background color in another background color
    By kevinvzandvoort in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2012, 11:04 AM
  4. [SOLVED] Change Background color of a Form Button or ActiveX Button
    By Aeneren in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-11-2012, 12:19 PM
  5. [SOLVED] No Color Palette, ActiveX
    By Rick Hansen in forum Excel General
    Replies: 1
    Last Post: 08-15-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