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
The course aims to take your skills in VBA in Excel to the next level. Applications covered include:
- Importing data into Excel
- Manipulating pivot tables
- Reporting
- Complex data manipulation
The course will expand on your existing knowledge of VBA by introducing a wider range of objects to help you build more complex and robust VBA procedures and functions.
Who is it for?
This course is ideal if you have some basic knowledge of VBA and good knowledge of Excel
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
Visual Basic for Applications (VBA) in Excel Part 2 follows on from Visual Basic for Applications (VBA) in Excel Part 1, and delegates should have successfully completed this or have equivalent knowledge.
Course contents
- Review: the Excel API, especially range objects; basic programming constructs: variables and variable types, if, for each, input and output in conjunction with type conversion techniques
- Looping structures: review of for-each; while loops; for-next loops
- More programming techniques: using a consistent programming style; Arrays
- Manipulating charts
- Workbooks: opening, saving, File search
- Manipulating pivot tables
- Complex applications: structuring programs using separate macros for separate tasks
- Error-checking and debugging: step into; step over; step out; on error resume; print debug; display alerts
- Workbook and worksheet events in detail
the end of the course, you will be able to:
- Be fully confident in the use of basic programming constructs
- Gain a thorough knowledge of key features of the Excel API: namely concerning ranges, workbooks and worksheets
- Write structured programs which integrate a number of separately defined tasks.