Microsoft Excel Visual Basic (Macros)
Training
In Edinburgh and Glasgow
Description
-
Type
Training
-
Level
Beginner
-
Location
-
Duration
2 Days
-
Start date
Different dates available
Learn how to program Microsoft Excel using VBA code. The course is designed to give delegates a thorough overview of programming within the Excel environment, enabling them to improve the functionality of their Excel spreadsheets.
Important information
Documents
- Microsoft Excel VBA 1 Day Overview.pdf
Government funding available
Facilities
Location
Start date
Start date
Start date
Start date
Start date
About this course
Expert VBA developers deliver this course
Reviews
Subjects
- Excel
- Programming
- Visual Basic
- Microsoft Office
- Microst
- Excel Formula
- Excel Sheet
- Spreadsheet
- Visual Basic training
- Microsoft Excel
- Microsoft excel training
- MS Excel
Teachers and trainers (1)
Cameron Foy
Training Consultant
As well as capabilities to advanced level in all the Microsoft Office Applications Cameron is very experienced in tailoring bespoke programming courses, for example in VBA, HTML to suit the needs of specific classes. Experience ranges from public scheduled courses to closed corporate training sessions for major financial institutions, public bodies and others.
Course programme
This course teaches experienced Excel users about the greater advantages to be gained by combining the built-in features of Excel with the programming capabilities of Visual Basic for Applications (VBA).
Visual Basic For Applications Overview
- The VBA Editor
- Program Structure
- Customising The VBA environment
Recording and Running Procedures
- Naming and Recording Procedures
- Controlling Reference Type
- Assigning Procedures
Viewing and Editing Procedures
- Reading Visual Basic Code
- Editing Visual Basic Code
- VBA Project Properties
Working with Visual Basic Code
- Variables
- Sub Procedures
- User Defined Functions
Objects, Properties and Collections
- Controlling Objects using Properties
- Performing actions with Methods
- Object Collections and Variables
User Input, Control and Looping
- User Input
- Control Structures
- Looping
Debugging and Error Handling
- Compile Errors
- Run-time Errors
- Logical Errors Debugging Code
Customising the User Interface
- Worksheet Forms
- Custom Dialog Boxes
Additional information
Microsoft Excel Visual Basic (Macros)