year change Simple shift planner in Excel VBA
Jan 24, 2026•Channel
AI Analysis
Data from YouTube Data API v3•Updated Just now
Video Overview
Video Details
Published5 months ago
Duration6:18
Video ID1e0ceA07ZJE
Languageen
CategoryScience & Technology
PrivacyPublic
Made for KidsNo
Video TypeRegular Video
Performance Metrics
Views3
Likes0
Comments0
Engagement Rate0.00%
Likes per 100 views0.00
Comments per 1K views0.00
Video Tags
Description
https://excel.hpage.com/simple-shift-planner.html
https://www.youtube.com/watch?v=9O0I1fgPwsA&list=PLcwMjDfa1J18yQm4lRwnPCyO0INpI16uQ
https://excel.hpage.com/create-programs-in-excel-vba-itself.html
Before changing the year or changing after the year, you should delete all collected data in the database with the "Delete all shift plans" button. The password for deletion is number 3. The warning is not turned off when this button is pressed.
With the button "Change year" in the program a calendar for selected
Create a year with floating and fixed holidays. The user determines the number and names of the fixed holidays. A maximum of 15 fixed public holidays can be assigned. The program has a list of 16 moveable holidays. Tick the checkbox of public holidays.
Click on the "Take over" button, enter a four-digit year in the input field and click on "OK". The calendar is created.
Public holidays have a red background color in the calendar. And still, in the calendar the date can only be selected from the list, simply entering the date in the combo box does not always work.