Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Use DateLastModified Property in VBA? | Excel Discussion (Misc queries) | |||
print property | Excel Discussion (Misc queries) | |||
How to get Signature property! | Excel Discussion (Misc queries) | |||
Question about "End(xlUp)" property | Excel Programming | |||
Question about "End(xlUp)" property | Excel Programming |