“Microsoft Excel” – Visual Basic for Applications

“Microsoft Excel” – Visual Basic for Applications
  • Event Category: Microsoft Office

The course schedule has not been scheduled yet. Please visit again soon.

ABOUT THE SEMINAR

The course is intended for advanced users who want to learn how to create macros in the “Microsoft Excel” program, master the basics of Visual Basic for Applications, including language syntax, loops, functions and procedures, objects, and events. Macros are used to speed up work and to combine repetitive actions into a single command.

SEMINAR PROGRAM
  • Introduction to macros. Purpose of macros. Types of macros and recording methods.
  • Using keyboard shortcuts to run macros.
  • VBA Editor
    • Structure of the VBA Editor:
    • Project Explorer
    • Properties Window
    • Work Area
    • Code Module
    • Object Browser
  • Executing functions and procedures in the editor.
  • Variables
    • Types of variables
    • Declaration
    • Using variables
  • Programming basics
    • Conditional statement (IF)
    • Loops (For, While)
    • User interaction tools (MsgBox, Input Method)
  • Procedures
    • Types of procedures
    • Creating and running simple procedures
    • Practical work with procedures
  • User Defined Functions (User Defined Function)
    • Types of functions
    • Creating functions
    • Using functions
    • Practical work with functions
  • “Excel” objects and events (Excel Objects and Events)
    • Workbook objects and events (Workbook Objects and Events)
    • Worksheet objects and events (Worksheet Objects and Events)
    • Range objects and events (Range Objects and Events)
    • Objects in a procedure (Objects In a Procedure)
  • Custom Forms
    • Creating and managing forms
    • Form properties (Form Properties)
    • Inserting objects into forms
    • Running forms
    • Practical work with forms
  • Creating a project using VBA.
  • Examples and analysis of macros.
  • Changing security settings.