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.
Bookmarks