1. Check out UserForms CommandButtons
2. With UserForms, Set controls to Visible = False
3. Timer Function
Use TextBoxes for questions and CheckBoxes for answers. Put them in a Frame Control and set the Frame Visible to False. Store the Answers on a sheet, or in an Array.
You can do it with Worksheets but there is no way to prevent a knowledgeable User from doing as he wants. In Excel, make the Forms Toolbox visible and use a Button. In the Buttons' Code set the current sheet.Visible to xlVeryHidden, and the next sheets Visible to True. Again, use a Timer function. Repeat for every sheet.
Bookmarks