Programming with VBA Excel

In this hands-on course, you will learn the basics of programming and VBA from the ground up. You will develop the skills needed to automate repetitive tasks, design interfaces for users and increase performance to improve user productivity.

Who should attend this course?

This course is interesting for anyone who wants to automate tasks through VBA programming.

Prerequisites

Experience in the use of Microsoft Office system products, particularly in Excel, is preferred. No previous programming experience is required.

During this 3-day training, participants will learn how to:

• Program with VBA.
• Develop custom solutions by using Visual Basic for Applications (VBA)
• Make the most of the VBA’s built-in construction.
• Leverage ActiveX controls to create functional user interfaces
• Fix the code using the VBA debugging tools.
• Secure your code and protect your users from macro viruses
• Use Visual Basic to control Excel, and to automate procedures that speed up and simplify working from Excel data.

You also learn how to set up interactive procedures by using message boxes and custom dialog boxes by using ActiveX controls. By the end of the course, you will have acquired a good understanding of Visual Basic language and methods of solving recurring tasks.