View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric Bentzen Eric Bentzen is offline
external usenet poster
 
Posts: 4
Default Property question

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