آموزش VBA در اکسل 2016 - رایگا

Excel 2016 VBA training in interactive voice and text Farsi - first, second and third chapters - free

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