VBA与API在Excel教学中的应用实例

Application Examples VBA and the API in the Excel Teaching

教学演示是软件教学中的重要环节,在演示过程和学生练习的同时,显示操作结果样张,能够对学生学习软件的操作提供更加有效的帮助。以Excel教学演示与学生练习为例,阐述应用VBA控件和API代码实现操作窗口与内容窗口的同步显示与灵活切换。

Teaching demonstration is an important part of teaching software, always show the results of operational requirements and to help students learn the software more efficient operation. In this article, describes application of VBA and the API to achieve the operating window and the contents window synchronization display and flexible switch, Take Excel teaching demonstration with the students for practiceas the example .