Visual Basic for Applications and Sheet No.

|OBJECT-ORIENTED PROGRAMMING |
|USING VISUAL BASIC 6.0 |
| |

CONTENTS

INFORMATION SHEET NO. 1: What is Visual Basic? 4
INFORMATION SHEET NO. 2: The Visual Basic Environment 5
INFORMATION SHEET NO. 3: Common Visual Basic Controls 11
Setting properties to a TextBox 12
Operations Sheet No. 1: Opening Visual Basic 6 14
Operation Sheet No. 2: Saving in Visual Basic 6.0 16
Operations Sheet No. 3: Closing Visual Basic 6.0 17
Operations Sheet No. 4: Inserting Object in Visual Basic 6.0 18
INFORMATION SHEET NO. 4: Variables 20
Explicit Declaration 20
Using Option Explicit statement 20
Scope of variables 21
Local Variables 21
Static Variables 21
Module Levele Variables 22
Public vs Local Variables 23
INFORMATION SHEET NO. 5: Datatypes, Modules and Operators 24
Modules 24
Data types in Visual Basic 6 24
Operators in Visual Basic 25
INFORMATION SHEET NO. 6: Control Structures 28
If...Then selection structure 28
If...Then...Else selection structure 28
Nested If...Then...Else selection structure 28
Select...Case selection structure 30
INFORMATION SHEET NO. 7: Looping structures 31
Do While... Loop Statement 31
While... Wend Statement 31
Do...Loop While Statement 31
Do Until...Loop Statement 31
The For...Next Loop 32
With...End With statement 33
INFORMATION SHEET NO. 8: Function and Procedures 35
Sub Procedures 35
Event Procedures 35
General Procedures 36
Function Procedures 37
Property Procedures 37
INFORMATION SHEET NO. 9: Control Arrays 38
Sharing Event Procedures 38
Creating Controls at Run Time 40
Iterating on the Items of a Control Array 43
Arrays of Menu Items 44
INFORMATION SHEET NO. 10: Database Terminology 46
OPERATION SHEET NO. 3: Creating Database Using Add-ins 49
OPERATION SHEET NO. 4:

References: |Single |Store floating point value in the range of (-3.4x10-38) - (+ 3.4x1038) | |Double |Store large floating value which exceeding the single data type value |