Word Document Properties


 Type a name for your certificate in the Your Certificate’s Name field



Download 8,82 Mb.
Pdf ko'rish
bet173/207
Sana16.03.2022
Hajmi8,82 Mb.
#496217
1   ...   169   170   171   172   173   174   175   176   ...   207
Bog'liq
VBA For Dummies 5th Ed.pdf ( PDFDrive )

2. Type a name for your certificate in the Your Certificate’s Name field.
3. Click OK.
You see a success message.
4. Click OK.
The test certificate is ready to use.
203
Chapter 8: Object-Oriented Programming
14_046500 ch08.qxp 12/5/06 5:36 PM Page 203


Applying the digital signature to a project
After you have a digital signature, you need to apply it to your project. Use
the following steps to sign your creation:
1. In the VBA Integrated Development Environment (IDE), choose
Tools

Digital Signature.
You see a Digital Signature dialog box, like the one shown in Figure 8-2.
2. Click the Choose button.
You see a Select Certificate dialog box.
3. Highlight a certificate in the list and then click OK.
VBA signs the target project using your certificate.
4. Click OK to close the Digital Signature dialog box.
Figure 8-2:
Verify the
signature
status of
your project.
204
Part III: Expanding Your VBA Horizons 
14_046500 ch08.qxp 12/5/06 5:36 PM Page 204


Chapter 9
Working with Arrays 
and Collections
In This Chapter
Using arrays within a program
Using collections within a program
Creating new data types
Defining collections within a program
T
o this point in the book, all the data types you’ve used have one thing in
common — they store a single data element. When you create an integer,
it holds a single number. Placing a new number within the integer removes
the old value. However, the real world doesn’t work this way. A computer can
have more than one disk drive. Your contact database contains more than
one name. A mailbox can contain more than one piece of mail. You need a
method of storing more than one piece of information in a single variable so
that you can model the real world in your programs. VBA provides two meth-
ods of doing this: arrays and collections.
Arrays
provide a way for your programs to store more than one item in a
single container. Think of the array as a large box with a bunch of small boxes
inside. Each small box can store a single value. You decide how many small
boxes the array can hold when you create the array. Use arrays when you
need to store a number of related items of the same data type.
Collections
always relate to a group or series of objects that are combined in
a single container. In most cases, a main object contains one or more sub-
objects. For example, an Excel 
Application
object contains a 
Workbooks
collection, and a 
Workbook
object contains a 
Sheets
collection. The
Application
can contain one or more 
Workbooks
, and an individual
Workbook
can contain one or more 
Sheets
. A Word 
Section
object can
contain a 
HeadersFooters
collection. Microsoft Office and many third-party
products are packed with object collections that you can access from VBA.
15_046500 ch09.qxp 12/5/06 5:36 PM Page 205


In this chapter, I also demonstrate how you can create your own data types.

data type
is a way to mark information so that you can understand it better.
The computer doesn’t care about data types. VBA uses data types to enforce
certain data behaviors, but it doesn’t really understand them. The use of a
data type is for your benefit so that you can understand the information
better.
Using Arrays for Structured Storage
An 
array
is a list of items. When you write a list of tasks to perform for the
day, you create an array. The piece of paper is a single container that holds a
number of strings, each of which is a task that you have to perform. Likewise,
you can create a single piece of paper in your VBA program — an array —
and use that array to hold multiple items.
Understanding array usage
You can define arrays by using several techniques. However, all these tech-
niques use the same basic approach. Listing 9-1 contains an example that
demonstrates the essential array usage process. (You can find the source
code for this example on the Dummies.com site at 
http://www.dummies.
com/go/vbafd5e
.)

Download 8,82 Mb.

Do'stlaringiz bilan baham:
1   ...   169   170   171   172   173   174   175   176   ...   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