Topics will be covered
• Error Handling
o Types of errors
o Trap the errors
o Error Handler
o On Error Resume Next
o On Error Goto Label, Line Number
o On Error Goto 0
o Resume, Resume Label, Resume Line Number
• Object Oriented Programming Concepts
o Classs
o Objects
o Class vs Objects
o Identifiers Attributes, Methods, Events
• Excel VBA Objects Hierarchy
o Important VBA Objects
o Object usage with Identifiers
• Application Object
o Application Object (Important) Properties
o Application Object (Important) Methods
o Application Object (Important) Events
• Workbook Object
o Application Object (Important) Properties
o Application Object (Important) Methods
o Application Object (Important) Events
• Worksheet Object
o Application Object (Important) Properties
o Application Object (Important) Methods
o Application Object (Important) Events
• Range Object
o Application Object (Important) Properties
o Application Object (Important) Methods
• User Interface
o Userform
o Label
o TextBox
o ComboBox
o ListBox
o CheckBox
o OptionButton
o ToggleButton
o Frame
o CommandButton
o TabStrip
o MultiPage
o ScrollBar
o SpinButton
o Image
o Application Object (Important) Methods
What is special in this course compare to other trainers?
• 26+ Years real-time experienced Software Professional.
• Teaching from the basic to advanced topic in methodological way.
• Explain all the logics with simple steps
• All concepts will be explained with realtime data
• Each macro concept will be explained in step by step in depth.
• On the spot practice
• Case Studies and Assignment for each concepts
• Online objective type test to check you knowledge
• Interview tips
Who should take up Excel VBA course?
Software Engineers and Data Analysts
Business Intelligence Professionals
Financial Specialist
Students
Any one who wants to automatic their excel daily tasks
What are the prerequisites?
Basic computer knowledge and installing software is required.
Should be through with My Excel VBA in Depth Level 1
Advanced Excel knowledge will be added advantage, but not mandatory