Question: In this project, you will write VBA code to implement the Canada holiday calendar. Specifically, your tasks include: (a). To develop a VBA function named

 In this project, you will write VBA code to implement the

In this project, you will write VBA code to implement the Canada holiday calendar. Specifically, your tasks include: (a). To develop a VBA function named IsBusinessDayTOR(datIn) that returns true if datIn is a Canadian business day and returns false if datIn is a Canadian holiday or weekend. Table 1 gives a list of Canadian holidays. To calculate the date of Good Friday, you can use the code from Exercise 2.6 in the textbook. (b) To develop a VBA function GetHolidaysTOR(1Y) that returns a list of Canadian holiday dates in year 1Y. (c). To implement a user interface in an Excel worksheet with one input and one button (The interface is similar to the one shown in Figure 2.2 of Chapter 2). The input is an integer representing a year. Clicking the button generates a list of Canadian holidays in the worksheet. In this project, you will write VBA code to implement the Canada holiday calendar. Specifically, your tasks include: (a). To develop a VBA function named IsBusinessDayTOR(datIn) that returns true if datIn is a Canadian business day and returns false if datIn is a Canadian holiday or weekend. Table 1 gives a list of Canadian holidays. To calculate the date of Good Friday, you can use the code from Exercise 2.6 in the textbook. (b) To develop a VBA function GetHolidaysTOR(1Y) that returns a list of Canadian holiday dates in year 1Y. (c). To implement a user interface in an Excel worksheet with one input and one button (The interface is similar to the one shown in Figure 2.2 of Chapter 2). The input is an integer representing a year. Clicking the button generates a list of Canadian holidays in the worksheet

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!