基于Excel VBA实现作业计划表自动刷新及滚屏的应用  

Application of automatic refreshing and rolling screen of job schedule based on excel VBA

作　　者：张士东 ZHANG Shi - dong(China Railway Shenyang Bureau Group Co. , Ltd. chifeng track maintenance division division, chifeng, 024000, Chin)

机构地区：[1]中国铁路沈阳局集团有限公司赤峰工务段,内蒙古赤峰024000

出　　处：《黑龙江交通科技》2018年第3期155-156,共2页Communications Science and Technology Heilongjiang

摘　　要：针对工务系统作业项目数量较多,很难掌握作业计划的状态和可视化效果差等特点,通过调用公式、编写VBA宏代码和设置控件,构建功能模块,开发了时间自动刷新、日报动态变化、自动排序及自动滚屏等功能,验证表明:本功能能够提高工作效率和降低工作难度,取得良好的效果。The number of work items in the public maintenance system, It is difficult to grasp the state of the operation plan and the poor visualization effect, By calling the formula, writing VBA macro code and setting the control, building functional module, developing the functions of time automatic refresh, daily dynamic change, automatic sorting and automatic scrolling, Test results show that. This function can improve work efficiency and reduce the difficulty of work, It achieves good results.

关 键 词：EXCEL VBA 刷新 排序 滚屏 

分 类 号：U212.33[交通运输工程—道路与铁道工程]