🗊Презентация VBA development technology. (Lecture 6)

Категория: Устройства и комплектующие
Нажмите для полного просмотра!
VBA development technology. (Lecture 6), слайд №1VBA development technology. (Lecture 6), слайд №2VBA development technology. (Lecture 6), слайд №3VBA development technology. (Lecture 6), слайд №4VBA development technology. (Lecture 6), слайд №5VBA development technology. (Lecture 6), слайд №6VBA development technology. (Lecture 6), слайд №7VBA development technology. (Lecture 6), слайд №8VBA development technology. (Lecture 6), слайд №9VBA development technology. (Lecture 6), слайд №10VBA development technology. (Lecture 6), слайд №11VBA development technology. (Lecture 6), слайд №12VBA development technology. (Lecture 6), слайд №13VBA development technology. (Lecture 6), слайд №14VBA development technology. (Lecture 6), слайд №15VBA development technology. (Lecture 6), слайд №16VBA development technology. (Lecture 6), слайд №17VBA development technology. (Lecture 6), слайд №18VBA development technology. (Lecture 6), слайд №19VBA development technology. (Lecture 6), слайд №20VBA development technology. (Lecture 6), слайд №21VBA development technology. (Lecture 6), слайд №22VBA development technology. (Lecture 6), слайд №23
Скачать
Вы можете ознакомиться и скачать презентацию на тему VBA development technology. (Lecture 6). Доклад-сообщение содержит 23 слайдов. Презентации для любого класса можно скачать бесплатно. Если материал и наш сайт презентаций Mypresentation Вам понравились – поделитесь им с друзьями с помощью социальных кнопок и добавьте в закладки в своем браузере.

Слайды и текст этой презентации

Слайд 1


VBA development technology
Описание слайда:
VBA development technology

Слайд 2


Main steps during task solving goal of the task; mathematical model; algorithm; structure of the data; GUI design; code writing; implementation with IDE; application analysis; testing; performing of a program; analysis of results.
Описание слайда:
Main steps during task solving goal of the task; mathematical model; algorithm; structure of the data; GUI design; code writing; implementation with IDE; application analysis; testing; performing of a program; analysis of results.

Слайд 3


Control names Name of a control is set up with Name property. Default names are: UserForm1; TextBox1, TextBox2; Label1, Label2. Prefix naming: <prefix><Basename> frmCheck; lblPrice; txtPrice; cmdCalculate
Описание слайда:
Control names Name of a control is set up with Name property. Default names are: UserForm1; TextBox1, TextBox2; Label1, Label2. Prefix naming: <prefix><Basename> frmCheck; lblPrice; txtPrice; cmdCalculate

Слайд 4


Common prefixes
Описание слайда:
Common prefixes

Слайд 5


Naming rules No more than 40 symbols. Names should be easy to read and understand txtNewPrice, txtNew_Price No spaces, dots and other special symbols instead underscore
Описание слайда:
Naming rules No more than 40 symbols. Names should be easy to read and understand txtNewPrice, txtNew_Price No spaces, dots and other special symbols instead underscore

Слайд 6


Dot notation <NameOfObject>.<Property> txtPrice.Text = 0 txtPrice.BackColor = vbYellow txtPrice.Visible = False Each control has its own default property which may be used without dot notation, e.g. txtCost.Text = txtPrice.Text*txtQuantity.Text is the same as txtCost = txtPrice * txtQuantity in case if all controls are TextBoxes.
Описание слайда:
Dot notation <NameOfObject>.<Property> txtPrice.Text = 0 txtPrice.BackColor = vbYellow txtPrice.Visible = False Each control has its own default property which may be used without dot notation, e.g. txtCost.Text = txtPrice.Text*txtQuantity.Text is the same as txtCost = txtPrice * txtQuantity in case if all controls are TextBoxes.

Слайд 7


Variables and constants Variables are used to store interim values Dim operator is used to describe such variables
Описание слайда:
Variables and constants Variables are used to store interim values Dim operator is used to describe such variables

Слайд 8


Variable description [Public|Private] Dim <VariableName> As <Data type>
Описание слайда:
Variable description [Public|Private] Dim <VariableName> As <Data type>

Слайд 9


Typical data types
Описание слайда:
Typical data types

Слайд 10


Constant description
Описание слайда:
Constant description

Слайд 11


Boolean data type
Описание слайда:
Boolean data type

Слайд 12


Logical operations Operand – value that takes part in operations Logical NOT is statement that is opposite to operand: 5 > 2 =True Not (5 > 2) = False Logical AND is a statement when both its operands are true, e.g. a < x < b is the same as (a < x) And (x < b) Logical OR is a statement when at least one of its operands is true. (i=5) Or (i = n)
Описание слайда:
Logical operations Operand – value that takes part in operations Logical NOT is statement that is opposite to operand: 5 > 2 =True Not (5 > 2) = False Logical AND is a statement when both its operands are true, e.g. a < x < b is the same as (a < x) And (x < b) Logical OR is a statement when at least one of its operands is true. (i=5) Or (i = n)

Слайд 13


Date and time datatype 8 bytes in memory Default USA format: #m/d/yy h:mm:ss# #9/23/06 19:40#
Описание слайда:
Date and time datatype 8 bytes in memory Default USA format: #m/d/yy h:mm:ss# #9/23/06 19:40#

Слайд 14


Functions to work with data
Описание слайда:
Functions to work with data

Слайд 15


Interval values for DateAdd and DateDiff
Описание слайда:
Interval values for DateAdd and DateDiff

Слайд 16


Transform to type functions
Описание слайда:
Transform to type functions

Слайд 17


Priority of operations 1. Arithmetical, 2. Comparison, 3. Logical.
Описание слайда:
Priority of operations 1. Arithmetical, 2. Comparison, 3. Logical.

Слайд 18


Variable assignment variable = value Firstly value on the right side is calculated, then result is assigned to variable. txtCost = txtPrice * txtQuantity
Описание слайда:
Variable assignment variable = value Firstly value on the right side is calculated, then result is assigned to variable. txtCost = txtPrice * txtQuantity

Слайд 19


Application with different data types Data type is assigned using Dim operator. You may use only variables those were described with Dim earlier. Option Explicit operator allows VBA environment to look about this rule
Описание слайда:
Application with different data types Data type is assigned using Dim operator. You may use only variables those were described with Dim earlier. Option Explicit operator allows VBA environment to look about this rule

Слайд 20


Назначение условного оператора Разветвляющийся процесс – из нескольких вариантов выбирают только один, причем выбор зависит от условия.
Описание слайда:
Назначение условного оператора Разветвляющийся процесс – из нескольких вариантов выбирают только один, причем выбор зависит от условия.

Слайд 21


Conditional operator One-line model is used when each branch contains no more than single operator
Описание слайда:
Conditional operator One-line model is used when each branch contains no more than single operator

Слайд 22


One-line model If Condition Then Operator1 Else Operator2
Описание слайда:
One-line model If Condition Then Operator1 Else Operator2

Слайд 23


Block model
Описание слайда:
Block model

Скачать

Похожие презентации
Mypresentation.ru
Загрузить презентацию