Microsoft Excel VBA and Macros (Basic)

Vê khóa học
Đối tượng
Mục tiêu
Nội dung

A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes. After you create a macro, you can edit it to make minor changes to the way it works. If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks.

Learning VBA for MS Excel, will allow you to automate existing things you do in Excel, so that you can save time and make your life easier. Excel VBA can help you do your work faster. It can also help you expand the true power of Excel in ways you never thought possible.

Anyone that uses MS Excel with no prior programming knowledge or VBA knowledge

Write VBA Code to automate the things you do in Excel
Use VBA Code to do things in Excel that otherwise wouldn't be possible
Save precious time at work by automating repetitive Excel tasks

Lesson 1: What Is Excel Macros?

Lesson 2: What Is VBA?

Lesson 3: Getting Started With Excel VBA

Enable the Developer tab
Security issues
Save a macro

Lesson 4: Recording A Macro

User Interface

Window elements
Standard toolbar

Editing the code

Lesson 5: Workbooks Object

Lesson 6: Worksheets Object

Sheets.Add method
Sheets.Copy method
Sheets.Delete method
Rename a worksheet
Hide/ Unhide sheets

Lesson 7: Range Object

Refer to Cells and Ranges by Using A Notation
Range properties and methods

Lesson 8: Worksheet.Cells Property

Lesson 9: Declaring Variables And Data Types

Data types
Declaring variables
Assign a value to a variable

Lesson 10: Using If...Then...Else Statements

Running statements if a condition is True
Running certain statements if a condition is True and running others if it's False
Testing a second condition if the first condition is False

Lesson 11: With...End With Statement

Lesson 12: Loops