Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
课程大纲
设施
- 创建您自己的工具栏和菜单
数据类型
- 转换为其他类型
- 变量的范围和生存期
- 运营商及其优先事项
- 选项模块
条件语句
- 选择案例
- 如果。。。然后。。。否则如果 ...还
循环
- 倒车循环时
- 对于每个循环
- 指令:循环断开(退出)
调试
- 加工步骤
- Traps 手表
- 局部变量窗口
- 即时窗口
- 调用堆栈
错误处理
- 捕获和处理运行时错误
- 结构:出错时继续下一个,错误 Go 时标记,错误 Go时至 0
- 数据显示在状态栏上
基本优化
- 屏幕更新
- 通过定时器方法测量宏的持续时间
VBA 表格
- 创建自己的表单
- 从代码调用表单
- 使用电子表格中的表单
14 小时
客户评论 (3)
举例说明,说明翻译方式
Aneta - LKQ Polska Sp. z o. o.
课程 - Visual Basic for Applications (VBA) in Excel (intermediate level)
机器翻译
主持人和参与者之间的互动,知识,对讨论和想法的开放性。
Paweł - LKQ Polska Sp. z o. o.
课程 - Visual Basic for Applications (VBA) in Excel (intermediate level)
机器翻译
There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.