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.
課程簡介
設施
- 創建自己的工具欄和菜單
數據類型
- 轉換為其他類型
- 變量的範圍和生命週期
- 運算符及其優先級
- 選項模塊
條件語句
- Select Case
- If ... Then ... ElseIf ... Else
循環
- 反轉循環時
- For Each 循環
- 循環中斷指令 (exit)
調試
- 處理步驟
- 陷阱監視
- 本地窗口
- 立即窗口
- 調用堆棧
錯誤處理
- 捕獲和處理運行時錯誤
- 結構: On Error Resume Next, On Error GoTo label, On Error GoTo 0
- 狀態欄上的數據顯示
基本優化
- ScreenUpdating
- 使用 Timer 方法測量宏的持續時間
VBA 表單
- 創建自己的表單
- 從代碼中調用表單
- 在電子表格中使用表單
14 時間：
客戶評論 (1)
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.
