BA (Visual Basic for Applications) is useful for integrating Microsoft's event-driven programming language Visual Basic with Microsoft Office applications such as Microsoft Excel, Word or Access. In event driven or event based programming the flow of the program is determined by events or user actions such as use of specific keys, mouse clicks or threads from other programs. VBA can be used to build customized solutions and programs to enhance the capabilities of the native Microsoft application.

Topics Covered

Introducing VBA What Is VBA? Introduction to Macro Recordings, IDE How VBA Works with Excel Working In the Visual Basic Editor Introducing the Excel Object Model VBA Sub and Function Procedures Using the Excel Macro Recorder Programming Concepts Essential VBA Language Elements Working with Range Objects Using VBA and Worksheet Functions Controlling Program Flow and Making Decisions IF, If Else, Else if, Select... While Automatic Procedures and Events Error-Handling Techniques Bug Extermination Techniques VBA Programming Examples Communicating with Your Users Simple Dialog Boxes UserForm Basics Using UserForm Controls UserForm Techniques and Tricks Accessing Your Macros through the User Interface Putting It All Together Creating Worksheet Functions and Living to Tell about It Creating Excel Add-Ins The Part of Tens Ten VBA Questions (And Answers) (Almost) Ten Excel Resources

Who should attend

Course is designed for the audience who has prior knowledge on Advanced excel, and keen to learn excel automation. This Program is designed for absolute beginner in VBA programming, which covers basic programming concepts to advanced level of programming..

Pre-requisites

Knowledge of Excel

What you need to bring

note book

Key Takeaways

Process Automation Tool Development - Excel Report Generation Automation Eliminate Manual Process/Manual Interaction Organize & Managing data easily using Tool Excel Based Automation Organizing data into Multiple workbooks/worksheets Dashboard Report, Standard Reports etc