+ Reply to Thread
Results 1 to 1 of 1

excel vba for quiz userform

  1. #1
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    excel vba for quiz userform

    Hello

    I have table with questions and multi answers with result counter for each question
    table.png
    and I have quiz userform
    userform.png

    I want when user open userform, lable1.caption get random question from table
    then system make random choose between two variables correct-incorrect
    if system choose correct, then lable2.caption get any correct answer for lable1 question
    if system choose incorrect, then get any other answers from another questions - so it will be wrong answer -
    user have two buttons, if he's choose is correct, add +1 in correct in table for answered question ( and same if incorrect )
    then again change the question and start again
    if user answer was incorrect, then show him the correct answer in lable3, before system go for next question

    and lets system not duplicate the questions in one shoot ( mean if user continue answering without close userform )
    note : some question have one or two answers and other answers is blank, so try to not get the blank one

    hopefully I can get help
    Thanks
    Attached Files Attached Files
    Last edited by Undo; 02-12-2021 at 02:43 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. Trying to make a multiple choice, 10 question quiz using UserForm
    By pvega96 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2019, 02:04 AM
  2. userform quiz
    By anjhuson in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-27-2014, 11:55 AM
  3. Create quiz using userform.
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2013, 05:15 AM
  4. quiz on excel
    By himanshug in forum Excel General
    Replies: 0
    Last Post: 07-13-2012, 01:21 AM
  5. Quiz in excel
    By mehtaavinash in forum Excel General
    Replies: 1
    Last Post: 08-16-2011, 07:00 AM
  6. Excel 2007 : excel quiz
    By the rock in forum Excel General
    Replies: 2
    Last Post: 09-11-2009, 06:31 PM
  7. Excel Quiz
    By bobbych in forum Excel General
    Replies: 0
    Last Post: 03-19-2007, 06:35 AM

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