+ Reply to Thread
Results 1 to 2 of 2

Cell fill colour depends on which radionbutton was selected.

  1. #1
    Forum Contributor
    Join Date
    10-01-2010
    Location
    Jakarta
    MS-Off Ver
    Excel 2003
    Posts
    101

    Cell fill colour depends on which radionbutton was selected.

    How to colourfill user selected cell where as the fill colour depends on which of the three radio buttons was selected.

    Do I need to add code in the Private Sub OptionButton1_Click() section first?

    Bart

    I am a newbie.

    What is the code?

    Below is the macro for the command button that populates the cell range, but need help for colourfill.


    Please Login or Register  to view this content.
    Last edited by vdongen; 10-10-2010 at 08:25 AM.

  2. #2
    Forum Contributor
    Join Date
    10-01-2010
    Location
    Jakarta
    MS-Off Ver
    Excel 2003
    Posts
    101

    Re: Cell fill colour depends on which radionbutton was selected.

    Currently I amusing data validation = list to activate right cell value, where each value represents fill colour.

    I want to have it replaced by Radiobutton. Below is some of the current code I use for the commandbutton that fill the colour.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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