Dear user, the application is only the first of three parts and is free of charge
For the rest of the
https://www.learninweb.com/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-vba-excel-2016.php
See.
This course is taught following:
Chapter One: Introduction to VBA and macros (free)
Introduction to VBA
What is macro?
How to make a macro for an Excel file
Macro procedure
View the Macro Code
Change the macro code
Create a macro for Excel
Add the macro to the Quick Access toolbar
Excel macros and hotkeys
Construction macro Sorting
Construction button to run the macro
Remove button created
To run the macro picture making
Chapter II: Working with functions and routines (free)
Understanding Modules
Method of making a routine
The rules specify the name of the procedure
Implementation process
The use of modules in other projects
Remove Modules
Enable Option Explicit
The implementation of a routine
Or function definition Function
Methods of performing a function
User-defined functions
Chapter III: The Beginning Programming with VBA (free)
Add a description to the program
Variable Definition
Determining the type of variable
A variable range
Variable publicly
Static variables
Definition of a fixed
Excel and VBA constants default
String variables and history
Operators
Array
Bidimensional Array
Chapter Four: Manipulation of cells in Excel
Addressing Excel cells using the Range object
Cells property
Offset property
Value property of a Range
Check an example
Text property
Count feature
Font properties
Numbers display format
Insert a formula in a cell using VBA
Activate object RANGE methods
Select the method object RANGE
Copy and Paste method.
Clear method and its variants
Delete method.
Chapter Five: work with Excel VBA functions
What is the function?
Date Functions VBA
Text manipulation functions with VBA
Len function
Left and Right functions
Mid functions and Replace
Using Worksheet Functions
Chapter VI: conditional statements and loops
If orders
Goto command
Select Case statement
For ... Next loop
Recipes For Each
IsNumeric function
Do ... While loop
Chapter VII: Events
Identify Events
Event open a WorkBook
Closing the WorkBook event
Event save a WorkBook
Event activate a Sheet
Name object property sheet
Event inactivation of a Sheet
Double-click and right-click event ID
Right-click the detected event
Change event of a WorkSheet
Event Move the cursor
Chapter Eight: identify and fix problem errors
Check an error
On Error GoTo structure
Error Resume Next paying attention to the error code is On
Identify the names and the error code
Chapter Nine: The relationship with the user
View message to the user with MSgBox
Download user with InputBox
Select a range of cells with the InputBox
Construction of the form to receive information from the user
Add Label to form
Change properties Form
Add buttons to form
Add code to form
Chapter Ten: working with other form controls (1)
Control frames
OptionButton Control
Sort placement controls
Enter the code for the form
CheckBox control
How to display the text on the button
Image Tools
Label control
TextBox controls
Chapter XI: work with other form controls (2)
Tab Control
Select the number of cells by the user by RefEdit
Slider bar controls or Scroll Bar
Spin tool
https://www.learninweb.com/ Education vba-excel.php
For the rest of the
https://www.learninweb.com/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-vba-excel-2016.php
See.
This course is taught following:
Chapter One: Introduction to VBA and macros (free)
Introduction to VBA
What is macro?
How to make a macro for an Excel file
Macro procedure
View the Macro Code
Change the macro code
Create a macro for Excel
Add the macro to the Quick Access toolbar
Excel macros and hotkeys
Construction macro Sorting
Construction button to run the macro
Remove button created
To run the macro picture making
Chapter II: Working with functions and routines (free)
Understanding Modules
Method of making a routine
The rules specify the name of the procedure
Implementation process
The use of modules in other projects
Remove Modules
Enable Option Explicit
The implementation of a routine
Or function definition Function
Methods of performing a function
User-defined functions
Chapter III: The Beginning Programming with VBA (free)
Add a description to the program
Variable Definition
Determining the type of variable
A variable range
Variable publicly
Static variables
Definition of a fixed
Excel and VBA constants default
String variables and history
Operators
Array
Bidimensional Array
Chapter Four: Manipulation of cells in Excel
Addressing Excel cells using the Range object
Cells property
Offset property
Value property of a Range
Check an example
Text property
Count feature
Font properties
Numbers display format
Insert a formula in a cell using VBA
Activate object RANGE methods
Select the method object RANGE
Copy and Paste method.
Clear method and its variants
Delete method.
Chapter Five: work with Excel VBA functions
What is the function?
Date Functions VBA
Text manipulation functions with VBA
Len function
Left and Right functions
Mid functions and Replace
Using Worksheet Functions
Chapter VI: conditional statements and loops
If orders
Goto command
Select Case statement
For ... Next loop
Recipes For Each
IsNumeric function
Do ... While loop
Chapter VII: Events
Identify Events
Event open a WorkBook
Closing the WorkBook event
Event save a WorkBook
Event activate a Sheet
Name object property sheet
Event inactivation of a Sheet
Double-click and right-click event ID
Right-click the detected event
Change event of a WorkSheet
Event Move the cursor
Chapter Eight: identify and fix problem errors
Check an error
On Error GoTo structure
Error Resume Next paying attention to the error code is On
Identify the names and the error code
Chapter Nine: The relationship with the user
View message to the user with MSgBox
Download user with InputBox
Select a range of cells with the InputBox
Construction of the form to receive information from the user
Add Label to form
Change properties Form
Add buttons to form
Add code to form
Chapter Ten: working with other form controls (1)
Control frames
OptionButton Control
Sort placement controls
Enter the code for the form
CheckBox control
How to display the text on the button
Image Tools
Label control
TextBox controls
Chapter XI: work with other form controls (2)
Tab Control
Select the number of cells by the user by RefEdit
Slider bar controls or Scroll Bar
Spin tool
https://www.learninweb.com/ Education vba-excel.php
Show More
