| |
- In House
- Public
- Distance
- Computer Based
- Other
|
|
|
Further Details
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
Excel Model Object
Application Object
Workbook Object and Workbooks Collection
Worksheet Object and Worksheets Collection
ThisWorkbook, ActiveWorkbook, ActiveCell, ....
Selection Object
Range Collection
Cells Collection
Using Status Bar
Screen Updating and Optimizing
Timer and Time Measuring
Events Handling in VBA
VBA Forms
Creating and Using Forms
Invoking Forms in VBA Code
Using VBA Forms in Worksheet
Guide price
1200 |
