Skip to Content
VB & VBA in a Nutshell: The Language
book

VB & VBA in a Nutshell: The Language

by Paul Lomax
October 1998
Intermediate to advanced
656 pages
16h 10m
English
O'Reilly Media, Inc.
Content preview from VB & VBA in a Nutshell: The Language
Collection.Add Method

Named Arguments

Yes

Syntax

objectvariable.Add item [, key, before, after]

objectvariable

Use: Required

Data Type: Collection object

The name of the Collection object to which an item is to be added.

item

Use: Required

Data Type: Any

An expression of any type that specifies the member to add to the collection.

key

Use: Optional

Data Type: String

A unique string expression that specifies a key string that can be used instead of a positional index to access a member of the collection.

before

Use: Optional

Data Type: String or Numeric

An expression that specifies a relative position in the collection. The member to be added is placed in the collection before the member identified by the before argument.

after

Key: Optional

Data Type: String or Numeric

An expression that specifies a relative position in the collection. The member to be added is placed in the collection after the member identified by the after argument.

Description

Adds a data item to a collection.

Rules at a Glance

  • If you don't specify a before or after value, the member is appended to the end of the collection.

  • If you don't specify a key value, you can't then access this member using a key, but instead must access it either by using its ordinal number or by enumerating all the members of the collection with the For Each...Next construct.

  • Whether the before or after argument is a string expression or a numeric expression, it must refer to an existing member of the collection, or an error (runtime ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Programming Excel with VBA and .NET

Programming Excel with VBA and .NET

Jeff Webb, Steve Saunders

Publisher Resources

ISBN: 1565923588Catalog PageErrata