Introduction to programming in Visual Basic for Applications (VBA)

Abstract

The tutorial discusses the basics of algorithmization and programming in Visual Basic for Applications (VBA), describes the action of linear, branching and cyclic structures. Much attention is paid to programming based on functions and procedures, processing one-dimensional and two-dimensional arrays, working with files. Examples of mathematical data processing, the use of spreadsheets for charting are given. In addition, the methods of creating macros, the principles of developing test programs based on various controls are considered. At the end of each Chapter there is a set of control questions and tasks. 
 It has an applied orientation and meets the requirements of the Federal state educational standards of higher education of the last generation.
 It is intended for students of higher educational institutions studying under the programs of bachelor of technical specialties, it will also be useful for students of secondary professional educational institutions and schoolchildren in preparation for the Unified state exam on the discipline "Informatics and ICT".