I assumed the return value would be assigned to something, perhaps an
appropriately declared variable, eg

myString = myobj.Properties(stfld)

Regards,
Peter T

"Bob Phillips" wrote in message
...
I think he means without the = Jean-Pierre.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jean-Pierre Bidon" wrote in message
...
The synatx "= myobj.Properties(stfld)" looks promising, unfortunately
it
is
not accepted by Excel.

"Peter T" <peter_t@discussions a écrit dans le message de news:
...
Doesn't the excellent suggestion posted by Robert Bruce do what you
want.
Adapting his example the syntax might be something like

= myobj.Properties(stfld)

Regards,
Peter T


"Jean-Pierre Bidon" wrote in message
...
Thank you for your answer.
Sorry, I was not clear. Your answer was not what I looked for.
I'll try to formulate it again with hopefully the right terminology.
I defined a class modul "myclass" and an instance "myobj".
Set myobj = New myclass
Let assume too that this class has 2 properties: "myfld1" and
"myfld2".
In other respects, I have a string variable {stfld} that is equal
either
to
"myfld1" or to "myfld2".
Is it possible to get (resp. set) the value of the parametrized
expression
myobj.{stfld} (syntax ??), that would be equal to :
- myobj.myfld1 if stfld="myfld1"
- myobj.myfld2 if stfld="myfld2"
Does it exist a way (either direct or indirect) to do it ?
Thanks for your help.


"NickHK" a écrit dans le message de news:
...
Jean-Pierre,
Your terminology is a little confusing.
In a class, you would normally talk about properties, methods,
events
etc.
So following the description below, something like

private m_myfld1 as string
private m_myfld2 as string
Public property Let myfld1 (vData as string)
m_myfld1=vdata
end property

Public property Get myfld1 as string
myfld1=m_myfld1
end property

If myobj.myfld1=stfld Then
...
ElseIf myobj.myfld2=stfld Then
...

Is that what you mean ?

Otherwise maybe you need to look in using a Collection "myfld"
objects
and
"stfld" is the key (if a string) or the index (if numeric).

NickHK

"Jean-Pierre Bidon" wrote in message
...
Hi,
My question concerns class object fields.
To be more specific, let assume I defined an object "myclass" and
an
instance "myobj".
Set myobj = New myclass
Let assume too that this object has 2 fields: "myfld1" and
"myfld2".
In other respects, I have a string variable {stfld} that is equal
either
to
"myfld1" or to "myfld2".
Is it possible to get the value of myobj(stfld), with a syntax
similar
to
DAO with Access ?
I know that the previous syntax doesn't work, so my question is :
does
it
exist an indirect (roundabout) way to do it ?
Thanks for your help.

--
Jean-Pierre Bidon
Interstat
5 place de la République
75003 Paris
Tél: 01 45 49 19 17