Excel User interfaces and optimization (VBA 4)

Current Status

Not Enrolled

Price

80 $

Get Started

Take this Course

Excel User interfaces and optimization (VBA 4)

( COMING SOON )

Discover the development with the VBA language

Objectives:

To be able to write vba procedures

Duration: 7 hours

Prerequisites:

Advanced user with a good command of Microsoft Excel and having experienced macros-commands

Back to the course list

Back to participant profile

Course Content

Before beginning

User interfaces 5 Topics

Lesson Content

0% Complete 0/5 Steps

Properties of the “Userform” interfaces

List of the most frequently used control elements

Properties of ActiveX controls

Examples of VBA procedures for interfaces

Sheet optimization 1 Topic

Lesson Content

0% Complete 0/1 Steps

Association of “Userform” forms and spreadsheets

Optimization of programmed procedures 7 Topics

Lesson Content

0% Complete 0/7 Steps

Temporary suspension of calculations

Force calculation (when automatic calculations are suspended)

Reactivating automatic calculations

Suspend the display of movements

Instruction that suspends cursor movements

Instruction that activates cursor movements

Calling a procedure

Additional training

Excel training – User interfaces and optimization