Visual Basic for Applications

Цена на курса: по запитване.

Програма на курса

1. Introduction to Programming

• Introduction
• VBA Editor
• Excel VBA Macros
• Access VBA Macros
• Outlook VBA Macros
• Creating a Dialog Box Using VBA
• Running VBA Macros as Standalone Application
• Primitive Data Types
• Variables
• Operators
• Exercises

2. Control Statements: Part 1

• if Single-Selection Statement
• ..else/if…elseif…else Double-Selection Statement
• while Repetition Statement
• Nested Control Statements
• Exercises

3. Control Statements: Part 2

• for Repetition Statement
• for…each Repetition Statement
• ..while Repetition Statement
• while…wend Repetition Statement
• do…until Repetition Statement
• switch Multiple-Selection Statement
• Exercises

4. Arrays

• Declaring and Creating Arrays
• Assigning Values to an Array
• Multidimensional Arrays
• Redim Statement
• Array Methods
• Exercises

5. Functions and Sub Procedures

• Program Components
• Function Definitions
• Function Call Stack and Activation Records
• Functions with Empty Parameter Lists
• Sub Procedures
• Calling Procedures
• Exercises

6. Strings and Date and Time

• What is a String?
• String Functions
• Date Functions
• Time Functions
• Exercises

7. Error Handling

• Syntax Errors
• Runtime Errors
• Logical Errors
• Err Object
• Error Handling
• Exercises

За записване и/или въпроси, свържете се с нас.