- Recording macros
- Editing macros
- Getting a message to/from the user
- Learning the environment (VBE)
- Home
- Simpliv Learning
- Courses
- 2 Days Live Virtual Training on Excel Macros and VBA Programming
2 Days Live Virtual Training on Excel Macros and VBA Programming
BY
Simpliv Learning
Online
2 Days
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
certificate availability
No
The syllabus
Features
Learning all about the most important object, the “Range” object
- Cells
- Offset
- Resize
- Directions
- Union
- Intersection
- Virtual worksheet
- Current Region
- Used Range
- Visible Range
- Special cells
- Areas
VBA Constructs
- If-then-else-End if
- Case-End Case
- And/Or
Loops
- For/Next
- Do/Until
- Do/While
- While/Wend
- Do/Loop
Scope of Variables (how long do they “live”?)
Creating a mini-application
- Add records to a list by VBA
User-defined Functions
Event programming
Taking action when
- A selection changes
- The worksheet is calculated
- A sheet is activated/deactivated
- Before a DoubleClick
- Before a right-click
Creating and using Userforms
Walking through a monthly maintenance application
- Creating it step-by-step