Page Comparison

...

1. Go to the Developer Tab.

   

2. Click Insert, and in the Form Controls section, click the Form Control buttonButton.

   

3. Click and drag in cell B1 to create a button at a size you want.

   

4. The Assign Macro box will appear, click Cancel.

   

5. Now double click your button and type “Clear Form.”

   

...

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

   

2. In the Visual Basic box, click Insert and choose Module.

   

3. In the text box, type in the code for your button.

   

   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.

   

6. In the pop-up Assign Macro box, click the Clear Form Macro in the Macro name and click OK.

   Image Removed

   Go back to the Developers Tab and click on the Macros button.

   Image RemovedImage Added

7. Next, click the Macro button in the Developer Tab.

   Image Added

8. In the Macro pop-up box, click the Clear Form Macro and click OK.

   Image Added

9. In the pop-up box, click the Options button and change the short cut to Control + Shift + C.

   Image RemovedImage Added

   1. Clicking those buttons in that order will allow students who only use keyboards to use the macros and clear the sheet.

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

    Image Removed

To make your macros accessible, follow these steps.

1. Each macro must have a clear and complete description of what it does.

2. Each macro must have a clear title that indicates its function.

3. A keyboard shortcut must be assigned to each macro.

4. The keyboard shortcuts or “hot keys” assigned to a macro must not match an existing short cut.

5. Users must be alerted that macros are being used in a document. They should know how many of them there are, the name, description, and hotkey of each macro.

Hot Keys Example

Instructions to adding a keyboard shortcut.

1. Go to the Developer Tab.

   Image Removed

2. In the Code section, click Record Macro.

   Image Removed

3. In the Record Macro box, create a name for your macro that is meaningful to what your macro does. In the Shortcut Key, type in the key you want to activate the macro. In Store Macro in: Choose “This Workbook” or the workbook you want the macro stored in. In description, explain what your macro does.

   Image Removed

4. Click OK.

Warning
CTRL C is already used in Excel as a hot key for copying. This cannot be used for another function. Image Removed

Tip
CTRL R is not used for anything in Excel, so it is safe to use for a macro. Image Removed

Hot Key Description Example

...

1. Image Added

Related articles