Скачать или смотреть Frame “Legend” Work planner with weekly calculation of the hourly difference Excel VBA

https://excel.hpage.com/work-planner-...
   • Work planner with weekly calculation of th...  
https://excel.hpage.com/create-progra...


The “Legend” button opens the Legend frame. You can enter up to 100 designations and abbreviations/codes in the “Absent due to” and “Workplace” fields. For “Department” you can enter a total of 20 designations.

When the list box in the frame turns blue, yellow, or green, a grey button becomes visible, the label on the button indicates which table view will be created when the button is clicked.

Incorrect names are deleted using dark red buttons. If something is deleted in the program, you will first be asked for the password; the password for deleting is always the number 3. The “Disable warning” checkbox can be seen in the input mask. If a tick is placed in the checkbox, the Warning disabled.

By double-clicking the left mouse button, you can select each line in the list box and display it in input fields that have the same colour as the list box.

The width of all columns in the list box automatically adjusts to the length of the data entered.