Results 1 to 10 of 10

Can background color of frame change on userform by combobox selection on userfor

Threaded View

  1. #1
    Registered User
    Join Date
    11-08-2011
    Location
    bergen county, NJ
    MS-Off Ver
    Excel 2007
    Posts
    72

    Can background color of frame change on userform by combobox selection on userfor

    I have 4 frames on a userform, each containing the option buttons for grading a student, 1 student per frame.

    what i'd really like to happen is that when a teacher selects his/her class from the combobox on the userform, the frames for the students in that class change to red...

    it would be really sweeeet, if then, when the teacher clicks a button in the red frame, the frame turns to green... (at the moment, it seems easiest to have ALL students have a frame on the userform... the color change would signal the teacher where to go, and the subsequent change from red to green would remind him/her that a choice was made)

    i'm attaching the workbook. i haven't attempted any code yet (actually i tried a few things but nothing worked). i have populated the comboboxes though...

    any help would be so much appreciated !
    this site rules !!!

    -rob
    Attached Files Attached Files
    Last edited by teacher_rob; 11-12-2011 at 11:27 AM.

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