560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
Open the file called WODA Application.xlsm and click the button on Sheet1 to apply to the Wise Owl Dating Agency. Take care to enter a valid date in the second input box.
If you enter an invalid date into this input box, you'll encounter a run-time error.
Find the subroutine called AddDetailsToList and identify this line of code:
YourDoB = InputBox("Enter your date of birth")
Add an On Error statement above this line which redirects the code to a separate section of the subroutine when a user tries to type in an invalid date.
Don't forget to disable your error-handler after this line using the On Error GoTo 0 statement.
Create an error-handling section at the bottom of the subroutine which displays a message to the user and then ends the procedure.
Your message could look similar to this one. Don't forget to add an Exit Sub statement just before the error-handling section.
Test the system works then save and close the file.
25 Aytoun Street