+ Reply to Thread
Results 1 to 1 of 1

How to change color of a button and assign value to it in Excel VBA

  1. #1
    Registered User
    Join Date
    12-16-2021
    Location
    Vietnam
    MS-Off Ver
    365
    Posts
    1

    Question How to change color of a button and assign value to it in Excel VBA

    I have 5 criteria. Each criteria has 5 different buttons (different color) represent for each option with a certain score for each.

    How to remain the color of a desired button and assign value to it when choosing, and in parallel the other buttons will change to the same color (grey for instance)? And at the same time, the comment cell will appear the describe text for the option that I chose

    After choosing the option for all criteria, we will have the overall score below

    Here is the mock-up for your reference

    Thanks a lot in advance for your help.

    Much appreciated.
    Attached Files Attached Files
    Last edited by joevn93; 12-17-2021 at 01:56 AM.

+ 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] Click oval option button to fill/unfill color, also change border color to match fill
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2015, 08:29 PM
  2. Change button color twice and release focus after second change
    By juriemagic in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2014, 02:35 AM
  3. Change the text color of a form button in Excel Mac 2011?!
    By RiTz21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2014, 06:25 PM
  4. Change Button Color
    By jeff_kaufman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2013, 02:15 PM
  5. [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
  6. [SOLVED] Button assign macro breaks with file name change and appears elsew
    By Student in forum Excel General
    Replies: 2
    Last Post: 07-25-2006, 04:10 PM
  7. [SOLVED] change the face color of an Excel command button
    By Chris Leah in forum Excel General
    Replies: 4
    Last Post: 07-12-2005, 10:05 AM

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