+ Reply to Thread
Results 1 to 4 of 4

Multiple Choice Test Interactive User Interface

  1. #1
    Registered User
    Join Date
    11-18-2020
    Location
    SLC, Utah
    MS-Off Ver
    Office Pro Plus 2016
    Posts
    2

    Multiple Choice Test Interactive User Interface

    I am trying to build a multiple choice test where the user clicks on one of the four answers and an answer cell records the answer and using conditional formatting the cell then changes the text red or green based on the correct response.

    is there a function that will return a value or perform a task if a cell is clicked (i.e., paste the value of the clicked cell in the "answer cell")?

    I have tried a bunch of functions and I think that I might have to turn to VB to get a return from a click...

    I have the conditional formatting done when the answer is entered into the answer cell...now i just want to simplify the user interface to allow a click on the presumed answer.

    Thoughts?

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,550

    Re: Multiple Choice Test Interactive User Interface

    .
    https://www.datanumen.com/blogs/make...m-sheet-excel/

  3. #3
    Registered User
    Join Date
    11-18-2020
    Location
    SLC, Utah
    MS-Off Ver
    Office Pro Plus 2016
    Posts
    2

    Re: Multiple Choice Test Interactive User Interface

    Thank you so much for the response...

    Regards,

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,550

    Re: Multiple Choice Test Interactive User Interface

    .
    You are welcome. Hope it works for your needs.

+ 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. Test generator for multiple choice questions
    By NickTank in forum Excel General
    Replies: 3
    Last Post: 07-31-2016, 08:52 PM
  2. Multiple Choice Mock Test With History
    By msuhaib in forum Excel General
    Replies: 1
    Last Post: 08-22-2015, 04:40 AM
  3. [SOLVED] Tallying a multiple choice test
    By Gippy222 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-06-2014, 03:45 PM
  4. In need of a template multiple choice test database
    By desnyder2001 in forum Access Tables & Databases
    Replies: 2
    Last Post: 09-01-2013, 10:56 PM
  5. Excel and interactive web interface
    By abousetta in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-14-2011, 09:40 AM
  6. Grading a multiple choice test in Excel
    By mburch in forum Excel General
    Replies: 2
    Last Post: 06-10-2008, 02:30 PM
  7. help - create a multiple choice test
    By robynhaga@gmail.com in forum Excel General
    Replies: 2
    Last Post: 07-17-2006, 07: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