VBA-based schedule management method and system

The invention provides a VBA-based schedule management method and system. The method comprises the steps of obtaining schedule data in a preset time period; inputting the obtained schedule data into a first storage table, and associating the schedule data in the first storage table with a calendar in a first display table by using a connection algorithm based on VBA; performing associated display of the calendar and the schedule task list through the first display table. According to the schedule management method and system, the operation interface and data management are constructed through the functions of the data table, the table formula and the VBA algorithm are used for controlling connection and operation of the data, the schedule management efficiency is improved, schedule customization development and application with high cost performance are achieved, and the development cost is greatly reduced. 本公开提供了一种基于VBA的日程管理方法及系统，获取预设时间段内日程数据；将获取的日程数据输入到第一存储表格中，利用基于VBA的连接算法将第一存储表格中的日程数据与第一显示表格中的日历进行关联；通过第一显示