Group: microsoft.public.word.vba.general
From: "Jonathan West"
Date: Friday, February 29, 2008 3:41 PM
Subject: Re: Objects as Properties in VBA - possible?


"chadwick" wrote in message
news:9b2c8324-f85c-45de-8e15-f83f14638439@d4g2000prg.googlegroups.com...
> Hello all,
> Is it possible for a property of an object in VBA to itself be an
> object? I'm working on a program that involves chemical equations,
> and consequently I have defined a couple of useful classes:
> "ChemicalCompound," and "ChemicalEquation." The ChemicalEquation
> class has as one of its members an array of ChemicalCompound objects,
> which represent the reactant compounds in the equation. I would like
> to keep the actual array private (i.e. access restricted to the class)
> and use a Property Get to access the ChemicalCompound objects in the
> array. Is possible for the return value of a Property Get to be an
> object of a user-defined class?

Yes. The syntax you use is like this

Property Get ReactantCompound(Index As Integer) As ChemicalCompound


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup