Excel VBA Macro Training for Corporate & Professionals in Chennai, Mumbai, Pune, Bangalore
DURATION: 16 Hours (2 Full Day)
Course Content:
OVERVIEW
What is VBA or Macros?. What it can be used for. Activate the Developer Tab. Macro Security Settings
RECORDING A MACRO
Naming & Recording a simple Macro. Recording using Relative & Absolute References. Editing a Recorded Macro in the VBA Editor. Saving the File as Macro Enabled Workbook
RUNNING AND ASSIGNING A MACRO
Running a Macro using a Toolbar. Assigning a Macro to a Button or Drawn Object on a Sheet. Assigning a Macro to a Quick Access Toolbar. Creating a Short-Cut Key to Run a Macro
THE VBA EDITOR
Opening and Closing the VBA Editor. Using the Project Explorer. Inserting a Module. Working with the Properties and Code Windows
UNDERSTANDING VBA TERMINOLOGY
Module, Procedures, Functions. Object, Property, Methods. Application, Workbook, Worksheet, Range
PROCEDURES
Creating a Sub Routine. Understanding the code structure. Commenting Statement. Calling procedures
USER INTERACTION
Creating an Interactive Message Box. Creating a Custom Input Box. Advantage of Application. Inputbox
CONDITIONAL STRUCTURES
Simple IF (IF…THEN) IF Else (IF…THEN…ELSE) IF & Logical Operators (IF AND/OR…THEN) Nested IF (IF…THEN…ELSEIF) SELECT CASE CASE ELSE
WORKING WITH RANGE
Referring to a Range Entering Values and Formulas Formatting Cells and Values With…Statement Using CurrentRegion Property Accessing a range using UsedRange Property The End Property Offset Select Special Cells Sort & Filter Rows and Columns (Insert/Delete/Autofit/Hide)
How can we help you?
Why Us
- Microsoft Certified Trainer
- Industry Expert Trainer
- Advanced Excel Training course
- Real World Examples
- Microsoft Certification
- Post Training Support
ERROR HANDLING & DEBUGGING
Understanding different Error Types
Debugging: Stepping through Code and Breakpoint On Error Goto Statement
Resume Next Syntax.
Excel Prodigy have conducted 750+ Excel VBA Macro Training for Corporate companies in Chennai & All Major Cities in India. We also conduct Excel Macro VBA Training Workshops in Chennai every month. Our trainer are experts in Excel VB Programming and created many Excel VBA Automation project for top level corporate’s.
EXCEL - VBA
Creating User Forms
Creating a custom form Adding text boxes to forms Moving controls Adding label controls to forms Changing text box and label properties Combo box, option, command
Working With Worksheets
Activate Worksheet Add/Delete/Rename a Worksheet Copy/Move a Worksheet Working with Group Worksheets Hide/ Protect Worksheets
User Define Functions
Using Excel Worksheet Functions in VBA VBA Function Creating User-Define Functions Using Range and declaring variables in User defined functions
Using Excel Events
Sequences of Events Events Associated with Worksheets Events Associated with a Workbook
Working With Application
Screen updating/ Display Alerts Cut copy Mode/ Username/ Speech
Working With Workbook
Open/Close Workbook Save/Protect Workbook This Workbook
