Excel IV - Macros (EN)

Description

Want to learn how to use macros to save time? Don't have the courage to edit macros in Visual Basic for Application code? Would you need any part of the commands to be repeated? Then this course is for you.

In this course we will show you what a macro is, where you could use it and what are the basic principles of macros in excel.
You will learn the basic syntax of properties and methods and understand how to substitute values and the ubiquitous use of the With and End With statements. 
You will learn how to make part of the statements repeated, create various conditions in the code that cannot be loaded, and learn about popular syntaxes.

Goals

• Naučit se vytvářet makra.
• Znát pravidla pro názvy a klávesové zkratky, Personal.xlsb
• Spuštění a možnosti maker.
• Edit macros in VBA code
• Be able to set some commands to repeat

Target

Contents

• Developer tab
• Excel in developer mode

• rules for names and keyboard shortcuts
• Personal.xlsb

• buttons on the Quick Access panel
• custom buttons in a worksheet
• macro options

• introduction to the environment
• projects, properties, modules

• Properties
• methods

• break mode
• stepping macro

• If… then… else
• For i… next i
• Do until / while… loop

• On error…

Prerequisites

Study Materials