Přístupnostní navigace
E-application
Search Search Close
Course detail
FP-APVAcad. year: 2025/2026
The course focuses mainly on creating projects and programs in the Visual Basic for Application development environment of MS Excel. The content of the course is teaching the VBA programming language in the MS EXCEL environment in order to acquire basic knowledge and principles of programming and skills in creating simple form programs or custom functions.
Language of instruction
Number of ECTS credits
Mode of study
Guarantor
Department
Entry knowledge
Basic knowledge of MS Excel from secondary school and high school curriculum
Rules for evaluation and completion of the course
To obtain a graded credit, it is necessary to obtain at least 50 points out of a total of 100 points for the credit test on VBA MS Excel.
Participation in lectures (odd week) is facultative, exercises in odd weeks are mandatory - practicing the material presented in the lectures, presence on exercises in even weeks is optional, these are so-called consultation exercises, intended for solving questions or problems with homeworks and specific issues on the topics of the material being practiced.
Aims
The main goal is to learn programming techniques with the support of current development tools in the creation of user programs or more complex projects.
Students will know theoretically and practically the philosophy of creating simple and more complex applications based on knowledge of general and modern programming techniques and algorithms, including knowledge of a specific development tool.
Study aids
see recommended study literature and e-learning portal
Prerequisites and corequisites
Basic literature
Recommended reading
Classification of course in study plans
Lecture
Teacher / Lecturer
Syllabus
1. Introduction to VBA, forms, worksheet and workbook event procedures, ActiveX controls
3. Objects, methods, properties, events, Range, Offset and Cells properties, variables, constants, working with variant data types, determining the data type of a variable
5. Structured variables, linking with ActiveX controls, conditions, branching
7. Cycles with different numbers of repetitions, with a control condition at the beginning and end of the cycle, cycles of set or collection elements (for every in)
9. Procedures, functions, modules, overloading, error handling techniques 11. Working with files, printing
13. Final consultation
Exercise
1. Course itinerary, course content, basic rules2. Introduction to VBA, forms, sheet and workbook event procedures, ActiveX controls3. Consultation4. Objects, methods, properties, events, Range, Offset and Cells properties, variables, constants, working with variant data types, determining variable data types5. Consultation 6. Structured variables, linking to ActiveX controls, conditions, branching7. Consultation 8. Loops with a constant number of repetitions, with a control condition at the beginning and end of the loop, loops of set or collection elements (for each in)9. Consultation10. Procedures, functions, modules, overloading, error handling techniques11. Consultation12. Working with files, printing13. Final test
Translated with DeepL.com (free version)
Self-study
Vypracování samostatných úkolů
Individual preparation for an ending of the course
Preparing for the credit from study materials - e-learning and literature