Understand the importance of VBA and learn how to use common VBA techniques in Excel®.
VBA is the programming language that is built into Excel® (and the other applications in the MS Office Suite). VBA is used to automate tasks that would otherwise have to be performed manually by pressing keys and selecting items with the mouse, and if that sounds like a macro, well it is. Although Excel® has a macro recorder, there’s a limit to what it can do. So where the macro recorder’s functionality ends, VBA takes over. At a more advanced level, VBA enables you to, amongst other things, build your own worksheet functions, create automated workflows and control and interact with other applications. This topic gets you started with VBA. It’s aimed at advanced users of Excel®, with little or no programming experience, who wish to take their level of automation knowledge beyond the macro recorder.
Learning Objectives
- You will be able to define some of the important VBA terminology.
- You will be able to describe how to edit a macro using VBA.
- You will be able to discuss how to use common VBA techniques such as looping and logic.
- You will be able to explain how to write a macro from scratch.
Agenda
Why Use VBA?
- To Edit Existing Macros
- To Get Past the Limitations of the Macro Recorder
- To Integrate Excel® With Other Applications
Running a VBA Macro
- Using the Built in Methods
- Creating a Button in the Spreadsheet
- Using a Keyboard Shortcut
Writing a VBA Procedure
- The VBA Editor
- Modules and Procedures
- Objects, Methods and Properties
- Documenting Your Code
- Event Driven Procedures
- Using If Logic
- Looping - Using VBA to Repeat an Action
- Protecting Your Code
Speakers
Mike Thomas,
theexceltrainer.co.uk- UK-based IT trainer with a career spanning 30+ years
- Delivered thousands of courses and produced hundreds of written and video-based tutorials
- Subject matter expert in a range of technologies with a primary focus and passion for Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI
- A fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organizations across a diverse range of industries, including healthcare, pharmaceutical, and public sector
- Designs and develops Microsoft Office®-based solutions that automate key business tasks and processes
Who Should Attend
This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, analysts, bookkeepers and accountants.
