Use VBA to automatically fill in the Date field in the absence template

First of all, the company every month at the end of the request staff to fill out the attendance information, and then sent a template, I think every time to fill in the date and the day of the week such information is more cumbersome, so think of a lazy way, but also made a change to the template style, so that its information display efficiency has been improved.

The simple thing to do is to use the VBA features that are available in office to automatically fill in fields that are regularly followed by a similar date in the attendance template.

In this way, each time you fill out the attendance record, you only need to fill in the monthly field information, and then click the template as a button to achieve the date and day of the week field information automation filled out.

"Template Download"

PS: As for my VBA code in Excel is how to write can be referred to "Baidu Experience: Excel VBA Basic use Method" To view, I hope you can have some gains ^ ^.

Use VBA to automatically fill in the Date field in the absence template