Excel Training – Develop an Automation Project with VBA
This Visual Basics for Application (or VBA) in Excel training module can be organized in Luxembourg, Brussels, Paris or anywhere within your offices. It is intended for participants who wish to set up a development project in VBA. The module focuses on all the tools, syntax, code, forms and functions required to take their automation skills a step beyond everyday macros. It is so satisfying when the result is produced by simply running a procedure.
Automate simple repetitive tasks
- Record a macro in Excel
- Save a workbook with macros
- Discover the VBA Editor and its environment: modules and projects
- Run a macro in VBA and Excel (including a button)
- Test a macro and identify the limitations of a macro command
- Record a procedure (with keyboard shortcuts, absolute and relative references, AutoFill)
Write code and structure a development project
- Define the practical rules of writing
- Structure a project plan
- Call a function
- Document a piece of code
- Run, test, and debug a procedure
- Secure and distribute using a personal workbook and distribution modules
- Understand Object-Oriented Programming: Objects, Methods, Properties, Parameters, and Object Explorer
Improve the development project with the Excel object model
- Use variables and constants
- Write reusable code
- Understand the Excel object model, the essential object properties and methods
- Use the main Excel objects (Workbook, Worksheet, Range)
- Communicate with the MsgBox, InputBox, and DialogBox user interfaces
Work with statements and functions
- Apply decision statements such as If Then Else and Select Case
- Use the For Next and Do Loop repeat statements
- Create a function and procedure with parameters
- Handle errors
Use event procedures and communicate
- Understand the event procedure with a workbook and a sheet
- Define and understand the role of a UserForm in Excel
- Describe the different objects in a form and the properties of form controls
- Retrieve, control and use data inputted in the form
- Communicate with Word, Outlook, or PowerPoint: reference a library and manipulate the Application object
Intermediate – 4 Days
1520€ face-to-face
1390€ remotely
Prices are without Tax and per person within a group including different companies.
Get in touch with us to schedule this course focusing on VBA in Excel or to get a quote for custom content.