Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tip

Another option is to type out the options then have the readers type in their answers.

Form for Marital Status has a number of choices. (Single, Married, Divorced, or Widowed)Image RemovedForm for Marital Status has a number of choices. (Single, Married, Divorced, or Widowed)Image Added

One exception to the rule on using buttons is that you are allowed to make simple ones that run a macro. A good example is a Clear Form button. The Clear Form button will clear your form and is accessible for users using screen readers or only keyboards. To create your Clear Form button,

...

  1. Go to the Developer Tab and click Visual Basic.

    The Visual Basic Button in Microsoft Excel
  2. In the Visual Basic box, click Insert and choose Module.

    The Insert Tab in the Visual Basic box with Module highlighted.
  3. In the text box, type in the code for your button.

    An example of code to use for making a clear form button perform the action.
    1. In the code, it says “Are you sure you want to clear the form?” This is in the code because a person can read “Clear Form” and know what it is. But a screen reader will not be able to read the Clear Form button. Just that a button is present. This question will be read by the screen reader and will alert the reader.

    2. Be sure you made changes to the code if you need it. For example, changing the range to reach your whole form.

  4. When you click the button, the question will pop up. If you answer “Yes”, the form will be cleared. If you answer “No,” nothing will happen.

  5. Right click your button and click Assign Macro in the expansion menu.

    The button expansion with the Assign Macro option highlighted.
  6. In the pop-up box, click the Clear Form Macro and click OK.

    The Assign Macro box with a Macro called Clear Form.
  7. Go back to the Developers Tab and click on the Macros button.

    The Macros button in Microsoft Excel. It looks like a grey piece of paper with a red paper to the right.
  8. In the pop-up box, click the Options button and change the short cut to Control + Shift + C.

    The Macro box to the left with the Options button in the bottom right corner. The Macro Options box is to the right with a short cut key set at Control Shift capital C.
    1. Clicking those buttons in that order will allow students who only use keyboards to use the macros and clear the sheet.

  9. To fulfill accessibility requirements, add instructions to cell A1 on how to use the Clear Form button.

    A complete form with a Clear Form button and instructions on how to fill out the form and how to clear the form and restart.Image Modified

Section 6.6: Locking and Protecting

...