Publication date : 04/04/2025
Course : Excel VBA, application development, advancedENI RS6430 certification optional.
Practical course - 3d
- 21h00 - Ref. EAV
|
Download in PDF format
Share this course by email
 | Build and optimize a VBA development project in Excel |
| Use the error manager to detect and correct problems |
| Create a dialog interface with the user in Excel using dialog boxes and messages |
| Develop data processing, display and publish data, using VBA programming |
Intended audience
Anyone wishing to develop VBA applications in Excel.
Prerequisites
Good basic knowledge of VBA and Excel or knowledge equivalent to that provided by the course "Excel, developing applications in VBA, level 1" (Ref. BAV).
Practical details
Hands-on work
Discussions and practical exercises.
Teaching methods
Active pedagogy based on exchanges, practical exercises and assessment of acquired skills throughout the course.
Course schedule
1 A reminder of the basics of development
- Recorded macros: advantages and limitations.
- Understand classic objects: application, workbook, sheet, range.
- Master basic syntax: conditionals and loops, variables and constants.
- Manage recoverable errors in code. Identify error types and use debugging tools.
Hands-on work
Limit Select instructions to optimize code. Use an error handler.
2 Advanced syntaxes
- Use object variables, array variables and dynamic arrays.
- Create custom functions and a library of complementary macros (AddIn).
- Call a procedure or function with ByRef or ByVal arguments.
- Using Windows APIs: key APIs for Excel development.
Hands-on work
Analyze a project and structure it with subprograms. Create functions that can be accessed from other workbooks.returnchariot
3 Advanced Excel objects, events
- Create lists, filters, subtotals, pivot tables: construction and manipulation through programming.
- Use Excel's calculation functions in VBA (WorksheetFunction).
- Automate graph creation and modification with VBA.
- Use workbook and sheet events. Use the Cancel argument. Secure workbook opening.
Hands-on work
Build a DCT or graph with VBA. Automate the implementation of calculated results on a range of cells.
4 User interface
- Program the import of external data (txt, csv...).
- Set parameters for opening and saving an Excel file (GetOpenFileName).
- Build a Userform containing multi-selection, cascading drop-down lists.
Hands-on work
Use a dialog box or UserForm to open an external file and process its data.
5 Other applications and file management
- Referencing a bookstore.
- Program the link with Word or PowerPoint: use automation.
- Access files in a folder (Dir or FileSystemObject).
Hands-on work
Automate a programmed table in Word or PowerPoint. Create, rename and delete files in a folder.
6 ENI certification
- Examination procedures.
- Personalized advice.
Options
Certification : 80 € HT
The ENI certification "Excel Macros and VBA language" is optional when you register for this course. Accessible online 24 hours a day or in person at a partner center, the assessment is timed (1h30) and includes practical cases and a MCQ/QCU. The practical cases, which reproduce a realistic work environment, are worth five times more than a MCQ/QCU question. The score out of 1000 determines the level reached: operational (500 to 700 points) or advanced (701 to 1000 points). Certification is obtained from 500 points and certifies skills in task automation, macro development and VBA programming on Excel. Results are available immediately after the test, and the certificate is sent by e-mail. This certification is registered under number RS6430 with the Répertoire Spécifique de France Compétences.
Customer reviews
4,6 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.
AWENA B.
26/01/26
5 / 5
I would have preferred to spend less time on the refresher course on the first day. I had taken the skills test before signing up for the course and I think that should have been a requirement as we didn't all have the same level.
PAUL G.
26/01/26
4 / 5
Ideal as an introduction to VBA and to discovering the specific features of Excel, the course material is also very detailed. I'd recommend this course for developers who want to learn the basics of VBA, rather than the beginner's level course, which is aimed at non-developers.
JULIEN B.
26/01/26
5 / 5
A very dense course, but the trainer was able to adapt to the levels and requirements of the candidates.very good teaching methods, combining practical and practical exercises, making the course very technical but accessible.the trainer was able to hold the attention throughout the course.
PARTICIPANTS
Anyone wishing to develop VBA applications in Excel.
PREREQUISITES
Good basic knowledge of VBA and Excel or knowledge equivalent to that provided by the course "Excel, developing applications in VBA, level 1" (Ref. BAV).
TRAINER QUALIFICATIONS
The experts leading the training are specialists in the covered subjects. They have been approved by our instructional teams for both their professional knowledge and their teaching ability, for each course they teach. They have at least five to ten years of experience in their field and hold (or have held) decision-making positions in companies.
ASSESSMENT TERMS
The trainer evaluates each participant’s academic progress throughout the training using multiple choice, scenarios, hands-on work and more.
Participants also complete a placement test before and after the course to measure the skills they’ve developed.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you need special accessibility accommodations? Contact Mrs. Fosse, Disability Manager, at psh-accueil@orsys.fr to review your request and its feasibility.
Anyone wishing to develop VBA applications in Excel.
PREREQUISITES
Good basic knowledge of VBA and Excel or knowledge equivalent to that provided by the course "Excel, developing applications in VBA, level 1" (Ref. BAV).
TRAINER QUALIFICATIONS
The experts leading the training are specialists in the covered subjects. They have been approved by our instructional teams for both their professional knowledge and their teaching ability, for each course they teach. They have at least five to ten years of experience in their field and hold (or have held) decision-making positions in companies.
ASSESSMENT TERMS
The trainer evaluates each participant’s academic progress throughout the training using multiple choice, scenarios, hands-on work and more.
Participants also complete a placement test before and after the course to measure the skills they’ve developed.
TEACHING AIDS AND TECHNICAL RESOURCES
• The main teaching aids and instructional methods used in the training are audiovisual aids, documentation and course material, hands-on application exercises and corrected exercises for practical training courses, case studies and coverage of real cases for training seminars.
• At the end of each course or seminar, ORSYS provides participants with a course evaluation questionnaire that is analysed by our instructional teams.
• A check-in sheet for each half-day of attendance is provided at the end of the training, along with a course completion certificate if the trainee attended the entire session.
• The main teaching aids and instructional methods used in the training are audiovisual aids, documentation and course material, hands-on application exercises and corrected exercises for practical training courses, case studies and coverage of real cases for training seminars.
• At the end of each course or seminar, ORSYS provides participants with a course evaluation questionnaire that is analysed by our instructional teams.
• A check-in sheet for each half-day of attendance is provided at the end of the training, along with a course completion certificate if the trainee attended the entire session.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you need special accessibility accommodations? Contact Mrs. Fosse, Disability Manager, at psh-accueil@orsys.fr to review your request and its feasibility.
Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class
Last places available
Guaranteed date, in person or remotely
Guaranteed session