| klste@hotmail.de |
Log work shift handover work shift change in Excel VBA
This program is an Excel file programmed in Excel VBA. It creates work shift handover log for 3 work shifts for whole year. In the program, all entered sequences of the work shift days are saved and the saved data can be made available by the program in the "Sheet" spread sheet for printouts.
In the program everything is done from one input mask. The input mask is activated in the "Mask" worksheet with the "Mask" button.
Work shift handover protocol is entered from a form. The form consists of 4 parts:
1 Calendar with layers,
2 Frame for the first production line,
3 Frame for second production line,
4 Annotation for 4 areas.
It is only entered if the date and work shift are selected.
All form fields with a yellow background contain data that can be entered in the database. All fields with a white background contain data that has already been entered.
It is better to only enter the work shift name in the "Team" field, because there is not much space for this term in the sheet view.
In the "Legend" worksheet, the user can specify names for several areas that will appear in the form and in the sheet view:
The name of the frame for the first production line is in cell A2
The name of the frame for the second production line is in cell E2
Production line status terms (for both production lines) are in the B2:B21 range
Product name of the first production line is in cell D2
Product name of the second production line is in cell F2
Each product is marked with a status, for example Done, Running. All this is in the area C2:C21 (for both production lines)
Name of the first area of the annotation is in cell G2
The name of the second area of the annotation is in cell H2
The name of the third area of the annotation is in cell I2
The name of the fourth area of the annotation is in cell J2
For each production line, the status should first be selected, for example "Produced" or "Stands".
Only 1000 product numbers can be entered per work shift and production line. The 1001 product number is simply not entered.
Each entered product number cannot be changed, it can only be deleted with the "Delete number" button. Password for delete is the number 3.
The product number in the list box can be selected by double-clicking the left mouse button, after double-clicking the selected number will be in the product number combo box.
Text in annotation fields can be of any length. If necessary, the text is split with line breaks. A line break is created by pressing CTRL + Enter.
The "Table view" button provides data from the selected layer in the "Sheet" worksheet for printouts.
A calendar for any year is created in the input mask via the "Change year" button.
In the list of 10 movable holidays, by activating the check box, the selected holiday is marked as a non-working day.
In the list of the 15 fixed holidays, users decide what name and date the holidays have and by ticking the checkboxes you mark the public holidays.
Click on the "Take over" button, enter a 4-digit year in the input field and click on OK. The calendar has been created.
The "Calendar" button creates a calendar in the "Sheet" worksheet.
With the "Delete database" button, all entered data of the protocol work shift handover are deleted. Password for delete is the number 3.