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

Категория: Устройства и комплектующие
Нажмите для полного просмотра!
VBA development technology. (Lecture 6), слайд №1 VBA development technology. (Lecture 6), слайд №2 VBA development technology. (Lecture 6), слайд №3 VBA development technology. (Lecture 6), слайд №4 VBA development technology. (Lecture 6), слайд №5 VBA development technology. (Lecture 6), слайд №6 VBA development technology. (Lecture 6), слайд №7 VBA development technology. (Lecture 6), слайд №8 VBA development technology. (Lecture 6), слайд №9 VBA development technology. (Lecture 6), слайд №10 VBA development technology. (Lecture 6), слайд №11 VBA development technology. (Lecture 6), слайд №12 VBA development technology. (Lecture 6), слайд №13 VBA development technology. (Lecture 6), слайд №14 VBA development technology. (Lecture 6), слайд №15 VBA development technology. (Lecture 6), слайд №16 VBA development technology. (Lecture 6), слайд №17 VBA development technology. (Lecture 6), слайд №18 VBA development technology. (Lecture 6), слайд №19 VBA development technology. (Lecture 6), слайд №20 VBA development technology. (Lecture 6), слайд №21 VBA development technology. (Lecture 6), слайд №22 VBA 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...
Описание слайда:
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:...
Описание слайда:
Control names Name of a control is set up with Name property. Default names are: UserForm1; TextBox1, TextBox2; Label1, Label2. Prefix naming: 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...
Описание слайда:
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 . txtPrice.Text = 0 txtPrice.BackColor = vbYellow txtPrice.Visible = False Each control has its own default property which may be used...
Описание слайда:
Dot notation . 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 As
Описание слайда:
Variable description [Public|Private] Dim As

Слайд 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) =...
Описание слайда:
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 *...
Описание слайда:
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....
Описание слайда:
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
Загрузить презентацию