Learn how to customise Excel using Visual Basic for applications.
Who should attend?
Anyone that needs to understand the programming language of Excel and develop and maintain complex worksheets including VBA.
Course overview
• Revision of recording Macros
• Creating Macros without using the Recorder
• Procedures
• Variables
• Conditional Testing
• Input and Testing Techniques
• Objects, Methods and Properties
• Functions in VBA perform all types of operations from simple tasks like summing cells to quite complex tasks involving statistical testing
• Specifying Arguments in Subroutines
• Error and Debugging Tools
• Error Trapping
• Custom User Forms
• Control Structures
• Dir Function
• Arrays
• Customising Command Bars
• Working with command bars programmatically
• Event procedures
• Add-In applications
Pre-requisites
An advanced knowledge of Excel ideally having a basic knowledge of recording macros.
Duration
3 days
Price
Onsite: £655 + VAT per day
Offsite: £795 + VAT per day
