ALL SOFTWARE EXERCISES
- EXERCISES HOME PAGE (942)
- Access 2010 (66)
- Access VBA Macros (17)
- Advanced VBA (29)
- DAX (0)
- Excel (37)
- Excel 2010 (83)
- Excel 2013 (10)
- Excel VBA Macros (49)
- Power BI - Excel 2013 (25)
- Power BI - Excel 2016 (24)
- Power BI Desktop (26)
- PowerPivot 2010 (26)
- Report Builder (42)
- SQL (192)
- SSAS - multidimensional (21)
- SSAS - tabular (29)
- SSIS Integration Services (40)
- SSRS 2012 (53)
- SSRS 2016 (43)
- Visual Basic (45)
- Visual C Sharp (65)
- WPF - Visual C# (20)
EXCEL VBA MACROS EXERCISES
Exercise: Add Error Handling to a Dating Agency Application
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.
The answer to the exercise will be included and explained if you attend the course listed below!
You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
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.
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.