Macros With VBA

This Course will help to write macros In Excel using Programming language Visual Basic Application (VBA).Recorded Macro can edited to customize it to fulfill 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.

Content:

• 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 variables
• 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

Eligibility:

• HSC and Above
• Bachelors Degree and Above
• Computer and Digital Media Awareness is Necessary