+ Reply to Thread
Results 1 to 1 of 1

"Cascading" Qustionaire

  1. #1
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    "Cascading" Qustionaire

    I started developing this in response to a question someone asked. It's a quick and dirty survey tool that could probably use some enhancement especially with trapping and gracefully exiting from errors. Anyway, it got me playing with forms which is something I don't get to do often.

    The questions are set up on the Questions sheet. You can have as many questions as you wish. Each Question should have a unique number in column A. The text of the question is in column B. The possible answers, separated by commas are in column C and where to go next based on the selected answer is in column D. For example question 4 is "What is your favorite fruit?", the three possible answers are Apple, Orange and Peach. If you answer Apple, you go on to question 5, if you answer Orange, you go onto question 6 and if you answer Peach, you go on to question 10.

    The results are recorded on the data sheet.

    On file open and when exiting the survey, the Current Question is reset to 1.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  3. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  4. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  5. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  6. "cascading" Cell References
    By manningda in forum Excel General
    Replies: 1
    Last Post: 05-01-2008, 02:19 PM
  7. Replies: 7
    Last Post: 05-13-2006, 05:02 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