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.
コース概要
The outline below is a suggested list of topics to be discuessed during the course of the training. The final curriculum may differ from the presented topics below, depending on the experience, expectations and needs of the participants.
Macros
- Recording and Modifying Macros
- Assigning Macros to Toolbar, Buttons, Shortcut key
Visual Basic for Applications Environment
- Visual Basic Editor and its options
- Component Management
- Shortcuts
- Environment Optimization
Introduction to Procedural Programming
- Procedures: Functions and Sub-routines
- Data Types
Control Flow
- If ...Then....Elseif....Else....Endif
- Case
- Do...Loop, While
- For... Next
- Exit
- Arrays and Loops
- Strings
Visual Basic
- VBA and Sheet Data Exchange (Cells, Range Methods)
- Getting and Printing Data from Users (InputBox, MsgBox)
- Variable Declaration
- Scope and LifeTime of Variables and Objects
- Operators and Their Priorities
- Modules Options
- Creating Worksheet Functions
- Objects, Classes, Methods and Properties
- Locking Project for Viewing
Debugging
- Run Time, Design Time, and Break Mode
- Brakes and Watches
- Local Window
- Immediate Window
- Call Stack
Error Handling
- Errors Types
- On Error GoTo
- On Error Resume Next
Events Handling in VBA
VBA Forms
- Creating and Using Forms
- Invoking Forms in VBA Code
- Using VBA Forms in Worksheet
要求
- Computer literacy
- Knowledge of any operating system
7 時間
お客様の声 (5)
例の表示、図による翻訳方法
Aneta - LKQ Polska Sp. z o. o.
コース - Visual Basic for Applications (VBA) in Excel (intermediate level)
Machine Translated
トレーナーの柔軟性。あらゆる質問に対する包括的な回答。
Krystyna Szpala - Sogecap SA Branch in Poland
コース - Visual Basic for Applications (VBA) for Analysts
Machine Translated
話題が尽きた
Karol - VOLKSWAGEN POZNAŃ SP. Z O.O.
コース - Excel Advanced with VBA
Machine Translated
I like the hands on training and seeing us solve for issues on the spot.
Jon Matrille - LocumTenens.com
コース - Visual Basic for Applications (VBA) in Excel - Advanced
Training Room and quite location and all the stuff.