آموزش VBA در اکسل 2019 on Windows Pc

VBA, which stands for Visual Basic for Application, is a type of Visual Basic programming language that you can use in Office. In this tutorial, VBA is implemented in Excel 2019.
The following is taught in the VBA training software in Excel 2019:

Chapter One: Getting to Know the VBA and Macros (Free)
Introduction to VBA
What is a Macro?
How to Create a Macro for an Excel File
Macro implementation method
View macro code
Change Macro Codes
Build a Macro for Excel
Add a macro to the Quick Access toolbar
Macros and Excel shortcuts
Build sort macro
Build button to run macros
Delete created button
Creating image to run macros


Chapter Two: Working with Functions and Procedures (Free)
Introduction to Modules
How to build a routine
Rules of Procedure Naming
Run the routine
Use module in other projects
Remove module
Enable Explicit Option
Methods of implementing a routine
Function Definition
Methods of executing a function
User Defined Functions


Chapter Three: Getting Started with VBA (Free)
Add description to app
Variable Definition Method
Specify the type of variable
Range of a variable
Definition of variables publicly
Static variables
Method of defining a constant
Default Excel and VBA constants
String type and date variables
Operators
Presentation
Bidimensional Array


Chapter Four: Manipulating Excel Cells
Addressing Excel Cells Using the Range Object
Cells property
Offset property
The Value property of a range
Consider an example
Text property
Property of Count
Font property
Numbers display format
Insert a formula into a cell using VBA
Activate method RANGE object
RANGE object Select method
Copy and Paste method
The Clear method and its variants
Delete method



Chapter 5: Working with Excel's VBA Functions
What is the function?
VBA history functions
Text manipulation with VBA functions
Len function
Left and Right functions
Mid and Replace functions
Using Worksheet Functions


Chapter Six: Conditional and Loop Commands
If
Goto command
Select Case command
Ring For ... Next
For Each command
IsNumeric function
Loop Do ... While


Chapter Seven: Events
Event Identification
The event of opening a WorkBook
The event of closing a WorkBook
The event of saving a WorkBook
Sheet Activation Event
Name property of the sheet object
Disable a Sheet event
Double-click and right-click event identification
Right click event identification
Change event of a WorkSheet
Cursor moving event


Chapter 8: Identifying and Troubleshooting Errors
Check for an error
On Error GoTo structure
Ignore Error Code On Error Resume Next
Identify error name and code


Chapter 9: Communication with the user
View user's message with MSgBox
Get from user with InputBox
Select a range of cells with InputBox
Create a form for receiving information from the user
Add Label to Form
Change form properties
Add Button to Form
Add code to form


Chapter 10: Working with Other Form Controls (1)
Frame control
OptionButton control
Sorting how controls are placed
Enter code for the form
CheckBox control
How to display text in buttons
Image tool
Label control
TextBox control


Chapter 11: Working with Other Form Controls (2)
Control Tab
RefEdit user selected number of cells
Scroll bar control or scroll bar
Spin Tool

VBA training in Excel 2019 under Windows and Android
https://www.learninweb.com/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-vba-excel-2019.php

VBA training in other versions of Excel under Windows and Android
https://www.learninweb.com/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-vba-excel.php

آموزش VBA در اکسل 2019 تعاملی و شبیه سازی شده با صدا و متن فارسی سه بخش اول رایگان بعد از دانلود نیاز به اینترنت در زمان آموزش نیست

Allows read only access to phone state, including the phone number of the device, current cellular network information, the status of any ongoing calls, and a list of any PhoneAccounts registered on the device.
Allows access to the vibrator.
Allows applications to open network sockets.
Allows using PowerManager WakeLocks to keep processor from sleeping or screen from dimming.