VBA EXPERT
Details
PRACTICAL DETAILS
Prerequisite: Intermediate MS Excel level
Time: 2-day workshop (From 9am to 5pm with an hour for lunch and two 15 minute breaks)
When: Nov. 30th & Dec. 1st 2016
Where: Kitsilano, Vancouver
Price: $850 (breakfast & lunch included)
Maximum of 10 students per class
IMPORTANT Please RSVP before November 28th: http://www.vba101.com/schedule-vba-expert
KEY FEATURES
In this advanced VBA workshop, we cover the following topics:
- Automatically create complex and dynamic userforms
- In-depth knowledge of the powerful listbox control
- Using arrays to manipulate large table much faster than Excel alone
COURSE CONTENTS
Automatic creation of dynamic UserForms
- Programmatically and dynamically add controls such as TextBoxes and ComboBoxes on a userform
- Automatically manage the controls
- Use class module
In-depth knowledge of the powerful listbox control
- Basic level : fill-in the listbox, manage interactions between listboxes
- Intermediate level : manage multi-culumns, transfer data from one list to another, managing titles
- Advanced level : filtering listboxes, drag and drop elements
Using array in VBA
- Overview of arrays
- Practical use of array
- Library of array functions
You need to bring your own computer at the workshop and have MS Excel. All the versions of MS Excel from Excel 2007 to 2016 are accepted. We work preferentially with Windows but other operating systems are welcome.
ABOUT THE SPEAKER
Gaëtan has a PhD in Management of Information Systems from Paris Dauphine University and Georgia State University. For more than 20 years, he has been teaching VBA, reporting and advanced use of MS Excel in the best European and North American Universities such as IESEG School of Management, Strasbourg University, GSU... Just the past month he taught VBA and Excel to more than a hundred of students!
Gaëtan developed over 80 applications for MS Excel for various industries (e.g. insurance, bank, textile) and domains (e.g. marketing, management, finance).
IMPORTANT
Please RSVP before November 28th: http://www.vba101.com/schedule-vba-expert
QUESTIONS?
Contact Océane DE DECKER, at contact@vba101.com or 778 708 1798
www.vba101.com (http://www.vba101.com/)