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.
Course Outline
Macros
- Recording and Modifying Macros
- Assigning Macros to Toolbars, Buttons, or Shortcut Keys
Visual Basic for Applications Environment
- Visual Basic Editor and its settings
- Component Management
- Keyboard Shortcuts
- Environment Optimization
Introduction to Procedural Programming
- Procedures: Functions and Sub-routines
- Data Types
Control Flow
- If...Then...ElseIf...Else...End If
- Case Statements
- Do...Loop, While
- For...Next
- Exit Statements
- Arrays and Loops
- String Manipulation
Visual Basic
- Data Exchange between VBA and Sheets (Cells, Range Methods)
- Retrieving and Displaying Data from Users (InputBox, MsgBox)
- Variable Declaration
- Variable and Object Scope and Lifetime
- Operators and Their Precedence
- Module Options
- Creating Worksheet Functions
- Objects, Classes, Methods, and Properties
- Locking the Project for Viewing
Debugging
- Runtime, Design Time, and Break Mode
- Breakpoints and Watches
- Locals Window
- Immediate Window
- Call Stack
Error Handling
- Types of Errors
- On Error GoTo
- On Error Resume Next
Excel Object Model
- Application Object
- Workbook Object and Workbooks Collection
- Worksheet Object and Worksheets Collection
- ThisWorkbook, ActiveWorkbook, ActiveCell, etc.
- Selection Object
- Range Collection
- Cells Collection
- Utilizing the Status Bar
- Screen Updating and Optimization
- Timing and Time Measurement
Event Handling in VBA
VBA Forms
- Creating and Using Forms
- Invoking Forms via VBA Code
- Implementing VBA Forms in Worksheets
Requirements
- Proficient knowledge of Excel.
Target Audience
- Data Analysts
14 Hours
Testimonials (1)
Working on and using our own data/spreadsheets, where we could see how it would benefit us most.
