+ Reply to Thread
Results 1 to 8 of 8

Change Command Button Colour Based on Cell

  1. #1
    Registered User
    Join Date
    04-19-2012
    Location
    Leeds, England
    MS-Off Ver
    Office for Mac 2011
    Posts
    17

    Change Command Button Colour Based on Cell

    Hi All,

    i would like to change the colour of a command butoon based on whether or not a cell has content in it. The code i have so far is:

    Please Login or Register  to view this content.
    Also when trying to change the colour of the button manually without any coding, it does not change, it just stays the normal grey colour.

    Thanks in advance.

    Adam[COLOR="Silver"]

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Change Command Button Colour Based on Cell

    I didn't have any issues with your code while it is in a userform. Is that where your code is?
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  3. #3
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    818

    Re: Change Command Button Colour Based on Cell

    Try this:
    Please Login or Register  to view this content.
    Kind regards, Harry.

  4. #4
    Registered User
    Join Date
    04-19-2012
    Location
    Leeds, England
    MS-Off Ver
    Office for Mac 2011
    Posts
    17

    Re: Change Command Button Colour Based on Cell

    yes my code is in a userform. It will allow me to change the forecolor but not the back colour

  5. #5
    Registered User
    Join Date
    04-19-2012
    Location
    Leeds, England
    MS-Off Ver
    Office for Mac 2011
    Posts
    17

    Re: Change Command Button Colour Based on Cell

    HSV that isnt working either

  6. #6
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,516

    Re: Change Command Button Colour Based on Cell

    See if you can gleam anything from attached.
    It works on MS computer.
    Attached Files Attached Files

  7. #7
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    818

    Re: Change Command Button Colour Based on Cell

    Quote Originally Posted by adam.hewitt5 View Post
    HSV that isnt working either
    Then upload your file.

  8. #8
    Registered User
    Join Date
    04-19-2012
    Location
    Leeds, England
    MS-Off Ver
    Office for Mac 2011
    Posts
    17

    Re: Change Command Button Colour Based on Cell

    i have decided to just either change the font colour or change the text on the button.

    Thanks anyway

    Adam

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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