Duration : 1 Month
Fees : 8500 /-
Creating Record Macros
- Recording a Macro
- Running a Macro
- Running a Macro from the Macros Dialog Box
- Creating a Short-cut key to run a macro
- Running a Macro with a Shortcut key
- Assigning a Macro to a Menu or Toolbar
- Editing a Macro with Visual Basic
Visual Basic Editor
- Objects
- Methods
- Properties
- Programming Tools
- The Menu Bar
The Project Explorer
- Using the Project Explorer
Using Constants
- Excel Constants
- Variable Constants
Excel Objects
- Objects, Properties and Methods
- Getting & Setting Properties
- Calling Methods
- Passing Arguments
- Singular Objects & Collections of Objects
Using Visual Basic Functions
- InputBox Function
- MsgBox Function
- Using a Set Statement
Building Formular Control Structures
- If Then Structures
- Logical Operators
- Select Case Janision Structures
- Case Else
- Comparison Operators with Select Case Structure
- For Loops
- Do Loops
- While...Wend Statement
Running Code
- Run mode and Design mode
- Running Code from the development environment
- Running Code from the host application
The Properties Window
- Changing a Property
Variables
- Dimensioning a variable
- Using variables in routines
- Object Variables
Userforms
- Designing & Creating Forms
- Working with Controls
- Userform Properties Methods & Events
Advanced VBA Programming Techniques
- Developing Excel Utilities with VBA
- Error Handling
- Using In-Built Excel Features in VBA
- Working with Pivot Tables
- Working with Charts
- Understanding Excel's Events
- Interacting with Other Applications
- Creating and Using Add-Ins