This is how data is entered Simple shift planner in Excel VBA

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 It is entered from an input mask. The input mask is activated with the "Mask" button, this button is located in the "Mask" spreadsheet. The mask can be moved by clicking at the top with the left mouse button. In the input mask with the "Shift planner" button, the "Shift planner" frame is called up, from the frame it is entered in the shift plan. The month is selected, then the calendar week. Entries are always made for a calendar week. The data entered for each week is always stored in the database. If month and week are selected, the data entered will be displayed in the shift schedule. Data for early shift is entered in columns A and D. Data for late shift is entered in columns G and J. Data for night shift is entered in columns M and P. If a row is selected in the selected column, the corresponding cell will be activated in the "Shift plan" worksheet, for example A12 or A44. Contents of the selected cell can be seen below the row number in the yellow box. The name of the employee is entered and, if necessary, the abbreviation is also entered. At the bottom of the shift schedule there is an area for abbreviations and explanations. In the combo box "Abbreviation" you can select the abbreviation or write any. In the "Employees" combo box, the name of the employee may only be selected from the list. Each entry cannot be changed, each entry can only be deleted, so if the selected cell is empty, the "Enter" button will be visible. And if something is entered in the selected cell, the "Delete entry" button can be seen. When deleting the entry, if the warning is not deactivated, you will be asked for the password, password is the number 3. The warning is deactivated in the input mask by ticking the checkbox "Disable warning about deleting entries". The lists of abbreviations and employee names are in the "Lists" worksheet. Employee names are in column A and abbreviations in column D. Font color and background color of employee names are adopted in the shift plan. You can enter as many abbreviations as there are rows in an Excel spreadsheet. Only 200 employee names can be entered. Each registered name corresponds to an employee account. When Employee Name is selected in Mask, “Sheet” button is visible. The button creates the selected account in the Sheet worksheet.