What is VBA?
Visual Basic is an object-oriented programming language developed by Microsoft. Using Visual Basic makes it fast and easy to create type-safe
Course overview
Using a step-by-step approach, this highly popular course shows how the Visual Basic for Applications (VBA) programming language can extend the functionality of Excel. You will learn to write macros to accept user input, read to and write from cells and manipulate data. You will also learn to write custom functions and create user forms. Useful examples of problems and their solutions are provided.
This short course is ideal for those with a good knowledge of MS Excel and would like to add additional functionality. No programming knowledge is required.
Who is it for?
This training is designed for Chief Accountants, Accountants, HR Professionals, Administrators, Economists and Planners, Customer Care officers and Secretaries, Project officers, Assistant accountants, Accounts officers, Budget officers, Finance Managers, Finance officers, Auditors, Audit assistants, Audit officers, Treasurers, Financial Analysts, Tax Consultants, Investment professionals and other interested professionals who want to transform their Microsoft Excel skills to the next level. Employees from Public and Private organizations are highly invited. If you want to develop competence in using Ms. Excel VBA features, this training is a perfect match to your career goals!
Key Learning Outcomes:
- Record, write, edit, test and run VBA macros with confidence
- Automate repetitive Excel business tasks and streamline workflow
- Write and apply User Defined Functions (UDFs)
- Implement event procedures
Eligibility
You should have a strong working knowledge of MS Excel to enroll on this course. You should be able to:
- comfortably use separate worksheets
- add/delete columns and rows
- basic formatting of spreadsheets
- use formulas and basic functions including IF() and ideally VLookup() and or CountIf().
Course contents
- Recording and running macros
- Assigning macros to menus, toolbars and buttons
- The Visual Basic editor
- Input boxes and Message boxes
- Object-oriented concepts: objects, properties, methods and events
- Excel objects
- Variables and constants
- If statements
- Looping
- Conversion functions
- User-defined functions
- User forms and dialog boxes
- Error-handling and debugging
- Workbook and Worksheet events
the end of the course, you will be able to:
- Record and run macros
- Use the Visual Basic environment to edit programs
- Write Visual Basic code, using variables, loops and if statements
- Understand Excel VBA functions and write their own functions
- Understand and apply object-oriented concepts
- Be acquainted with the most important Excel VBA objects and properties
- Understand events in Excel
- Debug (i.e. correct) errors.