Word Document Properties


Table 3-1 Compiler Options for VBA



Download 8,82 Mb.
Pdf ko'rish
bet65/207
Sana16.03.2022
Hajmi8,82 Mb.
#496217
1   ...   61   62   63   64   65   66   67   68   ...   207
Bog'liq
VBA For Dummies 5th Ed.pdf ( PDFDrive )

Table 3-1
Compiler Options for VBA
Option
Description
Option Base 
Use this option to change how VBA numbers array 
<Number>
elements. You can number array elements beginning at
0 or 1. In Chapter 9, I describe how to use arrays.
Option Explicit
Smart VBA programmers always add this compiler option
to their code. This option tells VBA that you want to
define variables before you use them. This option not only
makes your code easier to read, but can also help you
find typos in your code. Although the standard setting
treats 
MyVar
and 
MVar
as two variables, this option
forces VBA to question the misspelled version.
Option Compare 
Use this option to change how VBA compares strings. 
<Method>
When you’re using the Binary technique, VBA considers
hello and Hello different because the first form is in low-
ercase. Using the Text method means that VBA considers
hello and Hello as the same word because it doesn’t take
into consideration the case of the letters. The Database
technique, which is available only in Access, uses the
database sort order for string-comparison purposes.
Option Private 
Use this option to make a module private so that no other 
Module
module can see what it contains. The concept of public
and private is the object’s scope. The upcoming section
“Getting the Scoop on Scope” describes in greater detail
what scope means.
The 
Option Explicit
statement is so important that you should always
add it to a program. Listing 3-1 is a short example of how this feature works.
65
Chapter 3: Writing Structured VBA Programs
08_046500 ch03.qxp 12/5/06 5:34 PM Page 65


Listing 3-1

Download 8,82 Mb.

Do'stlaringiz bilan baham:
1   ...   61   62   63   64   65   66   67   68   ...   207




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©hozir.org 2024
ma'muriyatiga murojaat qiling

kiriting | ro'yxatdan o'tish
    Bosh sahifa
юртда тантана
Боғда битган
Бугун юртда
Эшитганлар жилманглар
Эшитмадим деманглар
битган бодомлар
Yangiariq tumani
qitish marakazi
Raqamli texnologiyalar
ilishida muhokamadan
tasdiqqa tavsiya
tavsiya etilgan
iqtisodiyot kafedrasi
steiermarkischen landesregierung
asarlaringizni yuboring
o'zingizning asarlaringizni
Iltimos faqat
faqat o'zingizning
steierm rkischen
landesregierung fachabteilung
rkischen landesregierung
hamshira loyihasi
loyihasi mavsum
faolyatining oqibatlari
asosiy adabiyotlar
fakulteti ahborot
ahborot havfsizligi
havfsizligi kafedrasi
fanidan bo’yicha
fakulteti iqtisodiyot
boshqaruv fakulteti
chiqarishda boshqaruv
ishlab chiqarishda
iqtisodiyot fakultet
multiservis tarmoqlari
fanidan asosiy
Uzbek fanidan
mavzulari potok
asosidagi multiservis
'aliyyil a'ziym
billahil 'aliyyil
illaa billahil
quvvata illaa
falah' deganida
Kompyuter savodxonligi
bo’yicha mustaqil
'alal falah'
Hayya 'alal
'alas soloh
Hayya 'alas
mavsum boyicha


yuklab olish