+ Reply to Thread
Results 1 to 5 of 5

VBA code for multiple choice quiz

  1. #1
    Registered User
    Join Date
    05-27-2022
    Location
    Alexandria, VA
    MS-Off Ver
    365
    Posts
    11

    VBA code for multiple choice quiz

    Hi,

    Trying to do a multiple choice (4) quiz, 50 questions, scored at end.

    Questions are in column A
    Multiple Choice Selections in columns B-E
    Answer in Column F

    Has a form with label for question, 4 option buttons for multiple choice answers and a <next> and <quit> button

    Looked at coding solutions on the internet but they all rely on populating the questions in the code itself, too inefficient. Tried ChatGPT but I keep getting coding errors.

    Any suggestions on how I should proceed?

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    31,244

    Re: VBA code for multiple choice quiz

    Please see yellow banner at top of page on how to attach a sample workbook
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Registered User
    Join Date
    05-27-2022
    Location
    Alexandria, VA
    MS-Off Ver
    365
    Posts
    11

    Re: VBA code for multiple choice quiz

    Here is the spreadsheet, sorry new to all of this...
    Attached Files Attached Files
    Last edited by Chopin1976; 03-12-2023 at 03:20 PM. Reason: no attachment

  4. #4
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

    Re: VBA code for multiple choice quiz

    Hello.
    I think that understanding what you want to do does not present any degree of complexity.

    However -I also think- that you could have presented a workbook that with a greater degree of certainty reflects what you have. That is why I am attaching another booklet that - I understand - is more similar to the one you have and to what you want to achieve: Could you look at it?...
    Attached Files Attached Files
    You are always very welcome if you add reputation by clicking the * (bottom left) of each message that has helped you.

  5. #5
    Registered User
    Join Date
    05-27-2022
    Location
    Alexandria, VA
    MS-Off Ver
    365
    Posts
    11

    Re: VBA code for multiple choice quiz

    Quote Originally Posted by beyond Excel View Post
    Hello.
    I think that understanding what you want to do does not present any degree of complexity.

    However -I also think- that you could have presented a workbook that with a greater degree of certainty reflects what you have. That is why I am attaching another booklet that - I understand - is more similar to the one you have and to what you want to achieve: Could you look at it?...
    Thank you, I might go with the simpler approach as my VBA coding is very rusty (been 20 years). Cheers

+ 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. Multiple Time Stamps depending on choice in Drop Down List Choice
    By insayah in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-25-2022, 09:53 AM
  2. How to add up a multiple choice quiz with different score for each answer
    By Myles-C in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-23-2021, 10:39 AM
  3. 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
  4. Multiple-Choice and True-False Test/Quiz Maker
    By leaning in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2018, 09:56 AM
  5. Make an multiple choice quiz with randomized choice
    By shaterroi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2015, 11:04 AM
  6. Multiple Choice Drop Down List VBA code issue
    By malwina.p in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2015, 08:14 AM
  7. [SOLVED] Making a multiple choice quiz
    By supern0va in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2012, 11:40 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