Results 1 to 3 of 3

Thread: Making a quastionaire - No clicking back

  1. #1

    Question Making a quastionaire - No clicking back



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hey guys!

    I am making a quastionaire in excel since other programs dont seem to do what i want. Now i have a couple of questions.

    1st - Can i make a click button to make someone go to the next sheet/question
    2nd - How can i make sure someone is not able to click back to the previous sheet
    3rd - Is there a possibility to let someone only look at a sheet for 20 seconds in which it then automatically goes to the next sheet without that person being able to go back to this sheet?

    Thanks a lot guys!

  2. #2
    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.

  3. #3
    Thanks a lot Sam!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •