Hi.

Is it possible to reference a property name using a variable?

Let's say I have a class module, clMyClass, with a string property named
"sMystring".

Now I would like to do something along this line:

Sub Example()
Dim sText as string
Dim vVar

sText = "Text to put in the property sMystring"
vVar = sMystring 'Actually I find the property name elsewhere
clMyClass.vVar = sText

End Sub

But this fails. I cannot make it work either if I use an object instead of a
variant. Any suggestions?

Regards Eric Bentzen

Eric,

In Excel 2000 and later, you can use the CallByName function to do
this. E.g.,


Dim PropName As String
PropName = "Value"
CallByName clMyClass, PropName, vbLet, sText

See help for CallByName for more details.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Eric Bentzen" wrote in message
...
Hi.

Is it possible to reference a property name using a variable?

Let's say I have a class module, clMyClass, with a string
property named
"sMystring".

Now I would like to do something along this line:

Sub Example()
Dim sText as string
Dim vVar

sText = "Text to put in the property sMystring"
vVar = sMystring 'Actually I find the property name elsewhere
clMyClass.vVar = sText

End Sub

But this fails. I cannot make it work either if I use an object
instead of a
variant. Any suggestions?

Regards Eric Bentzen