Intermediate VBA in Excel
Short course
In London, New York (USA) and Amsterdam (Netherlands)
Description
-
Type
Short course
-
Level
Intermediate
-
Location
-
Duration
1 Day
The purpose of this one day workshop is to take delegates VBA knowledge to the next level.
After this course delegate will be quicker and more efficient in VBA programming. They will also be able to produce complex user interactions through advanced userforms and automate some fundamental tasks such as emailing Excel content
Facilities
Location
Start date
Start date
Start date
Start date
About this course
This course is primarily intended for those people who have attended the ‘Introduction to VBA in Excel’ course.
However, someone who is already familiar with VBA would also benefit from attending and we would recommend looking at both course outlines to select the one containing the largest amount of relevant, new, material
Reviews
Subjects
- VBA
- Excel
Teachers and trainers (1)
TBC TBC
TBC
Course programme
The purpose of this one day workshop is to take delegates VBA knowledge to the next level.
After this course delegate will be quicker and more efficient in VBA programming. They will also be able to produce complex user interactions through advanced userforms and automate some fundamental tasks such as emailing Excel content
Specifically, participants will learn:
- Full VBA data type understanding
- Use of the Immediate window
- User defined functions
- Add-ins
- Personal macro workbooks
- Loop structures other than FOR NEXT
- Pivot tables with VBA
- Advanced Userforms
- Event procedures including non object related events
- Automating email from within Excel
Intermediate VBA in Excel