Duration: 2 Months
This Course will help to write macros In Excel using Programming language Visual Basic Application (VBA). Recorded Macro can edited to customize it to fulfil our requirement and one can directly go for coding to accomplish the required tasks. One can write his own functions and procedures, design forms and working with add-ins using VBA-Macros.
Macros with VBA
Macro recording
- Absolute and relative recording
- Macro storage locations
- Running macros from toolbars, menus or worksheet buttons
Visual Basic Editor
- Understanding modules
- Window options – immediate
- Editor formats
- Editor Toolbar
- Commenting code
- Code editing including stepping.
Understanding Objects, Methods, Properties and Variables
- What is an object?
- The object hierarchy
- Properties
- Methods
- Variable- types of variables, declarations and use of variable
Control Structures-Decision
- Making
- The IF control structures
- Else If
- Select Case
VBA Functions
- Creating User Defined Functions
- Using VB Functions
- Referencing Excel Worksheet Functions
- Calling Functions from a procedure
Interactivity
- Using Message Boxes and Input Boxes
- Learning Auto Events
Looping Structures
- Do Until Loops
- For …Next Loops
- For Each…Next Loops
User Forms and GUI
- Designing Forms with VBA
- Components of the User Form Object
- Adding ActiveX Controls to a Form
- Showing and hiding Forms
- Designing Custom Dialog Boxes Using Forms
Error Handling
- Using Error Handling Statements User Forms
- Building Custom User Forms
- Referencing Built-in User Forms
Addins
- Creating an Addin
- Installing an Adding