VBA


Objective

VBA (Visual Basic for Applications) is very widespread thanks to its availability in Microsoft Office. Combined with VBA, which is used as its macro language, Microsoft Excel has become a de facto standard, firstly in banks and then across all sectors. This success arises from the need to manipulate data and automate processing and calculations, which are all tasks that often confront statisticians.

 

Planning

  1. The VBA development environment
  2. VBA: Types, definition of variables, constants, arrays. Assignment, flow control, loops. Scope of a variable, memory. Functions, procedures, argument passing.
  3. Interaction between Excel and VBA: Recording macros. Rewriting and adapting the recorded code. Using Excel objects.
  4. Example of algorithms and implementation in VBA

 

Références