Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm sure this is possible.
I have written a class module which contains a number of properties. I wish to change the value of one of the properties, however I want to dynamically identify the property that I'm changing For example: if my class has integer properties of X and Y I wish to be able to do somthing similar to below ======================================== Function Change_Value(strProperty as String, iValue as Integer) Dim objClass As myClass Set objClass = New myClass objclass(strproperty) = iValue End Function ========================================= Thanks in Advance Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Get Property value of class instance by passing string property name | Excel Programming | |||
Error: Cannot Set Range Class Property | Excel Programming | |||
How to cycle through each of property and its value of Class? | Excel Worksheet Functions | |||
Cannot set HorizontalAlignment Property of the Range Class | Excel Programming | |||
Access to class property in other workbook | Excel Programming |