Use CallByName:

Dim Res As Variant
Dim PropName As String
Dim Obj As New Class1
' some code to set up Obj
PropName = "MyProperty"
Res = CallByName(Obj, PropName, VbGet)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

wrote in message
oups.com...
Does anyone know how to get the value of a property of an instance of
a class by passing the string as the name of the property?

I have seen it somewhere before e.g.
GetPropertyValueForClass(myClass,"PropertyName")

Any help would be really appreciated

Thanks

Mark