year change Simple shift planner in Excel VBA

Jan 24, 2026Channel
AI Analysis
Data from YouTube Data API v3Updated Just now
excelgeist
excelgeist

3.9K subscribers

View Channel

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

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.

Related Videos

More videos from excelgeist