Need calendar form to display holidays

M

mazza.j

I have a calendar form that's created using VBA. I need it to display those
days that are holidays (use different color or something). Dealing with
Massachusetts, so there are 13 different legal holidays. Obviously the actual
date changes each year for some, so ideally I'd like the holidays to be
determined using code so that the user doesn't have to input the specific
dates (fewer mistakes that way).

1 New Year’s Day - January first
2 Martin Luther King Jr.'s Birthday - Third Monday in January
3 Presidents' Day - Third Monday in February
4 Evacuation Day - March 17th (Suffolk County only)
5 Patriots' Day - Third Monday in April
6 Memorial Day - Last Monday in May
7 Bunker Hill Day - June 17th (Suffolk County only)
8 Independence Day - July 4th
9 Labor Day - First Monday in September
10 Columbus Day - Second Monday in October
11 Veterans’ Day - November 11th
12 Thanksgiving Day - Customarily the fourth Thursday in November
13 Christmas Day - December 25th
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top