Versions Compared

Version Old Version 47 New Version 48
Changes made by

Daniel LaGrow

Daniel LaGrow

Saved on

Key

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

...

  1. Choose a category you want an alert to appear for.

    Data Validation without Alert Example.pngImage RemovedMilitary Registration Form with the Date of Birth fill in section highlighted. There are instructions next to it in a yellow box.Image Added

  2. Go to the Data Tab, then click the Data Validation Button.

    Data Tab in Microsoft Excel.Data Validation Button with a green checkmark and red sign.

  3. In the Data Validation Settings Tab, change them to suit your needs. In Error Alert, type in a clear message on what has to be changed in the file in order to continue with the page.

    Data Validation box with settings tab open.Image RemovedData Validation Box with Error Alert tab open.Image RemovedData Validation box with settings tab open. Date restrictions are set between October 4th, 1994 and October 4th, 2006.Image AddedData Validation Box with Error Alert tab open with a message saying your date of birth is outside of our age limit.Image Added

  4. If the wrong information is typed into the box, your warning should appear.

Info

Now we have an error for birthdates. If someone types in a date before or after our age limit or an inaccurate date, they will be alerted. Remember, if an input field is required, the user must be alerted.

Microsoft Excel warning asking to enter a valid date of birth.Image RemovedMicrosoft Excel warning saying that your date of birth is outside of our age limit.Image Added

  1. Finally, make sure that if you have fields that are required, you need to add an alert to the reader so they know how many input fields they need to fill.

Warning

This form does not have any hints or indications that all the fields need to be completed. Readers may get confused if they have to fill the whole form or not.

A military registration form with no indication that all fields need to be filled.Image RemovedA military registration form with no indication that all fields need to be filled.Image Added
Tip

This form tells the reader that all fields must be filled to submit the form.

Registration form with an indicator that all fields are required to be filled.Image RemovedRequired Fields Warning Example.pngImage Added

Section 6.5: Form Controls and ActiveX Controls

...