+ Reply to Thread
Results 1 to 7 of 7

VBA Status of Pass/Fail Required on Userform

  1. #1
    Registered User
    Join Date
    07-16-2012
    Location
    Johannesburg, south Africa
    MS-Off Ver
    Excel 2007
    Posts
    10

    VBA Status of Pass/Fail Required on Userform

    Per the attached, I have a set of questions which must be answered by true or false. the answer to all is true. I need a pass/fail indicator on the userform to give a user realtime view based on percentage of true answers. threshold can be assumed as 80% where below it is reflected as fail

    Please helpCapture_Excel Forum Query.JPG
    Attached Files Attached Files
    Last edited by Dereshp; 05-09-2014 at 12:25 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,402

    Re: VBA Status of Pass/Fail Required on Userform

    What use is a picture?
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-16-2012
    Location
    Johannesburg, south Africa
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: VBA Status of Pass/Fail Required on Userform

    Hi there - my apologies - I have included the above - I hope you are able to help

    thanks

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,402

    Re: VBA Status of Pass/Fail Required on Userform

    have replaced your checkboxes with option buttons; the checkboxes allow two answers for each question, the option buttons only one.
    The code below is in a class module to handle option button click events:
    Please Login or Register  to view this content.
    The below presents the update on the form as a progressbar, i.e., label
    Please Login or Register  to view this content.
    Then in the userform:
    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-16-2012
    Location
    Johannesburg, south Africa
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: VBA Status of Pass/Fail Required on Userform

    Thanks for your help "protonleah" - really appreciated.

    I would however like the option buttons not to be locked to a selection. this way if a user inputs an incorrect choice he can still change this and influence the score appropriately.

    Thanks

  6. #6
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,402

    Re: VBA Status of Pass/Fail Required on Userform

    The code does not lock the answer to a question, I didn't write the code for that. Also, if an answer is changed from true to false the score does not reflect the change.

  7. #7
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,402

    Re: VBA Status of Pass/Fail Required on Userform

    I have modified the macros to reflect changes in answers.
    Attached Files Attached Files

+ 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] Need a formula for pass/fail based on no. of Y answers but automatically fail if 3a is N
    By Researcher1111 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-15-2013, 10:20 PM
  2. [SOLVED] Pass And Fail
    By thong127 in forum Excel General
    Replies: 9
    Last Post: 06-11-2013, 05:17 PM
  3. If <> Then pass , otherwise fail help needed
    By Nero_slk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2013, 05:11 AM
  4. Replies: 5
    Last Post: 03-16-2010, 07:05 AM
  5. pass fail
    By Tricia in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-20-2005, 12:06 PM

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