How can I dynamically select a class property using a string variable? [duplicate]

Question

Suppose my class has a couple of similar properties and I want to select one dynamically based on a string variable:

MyClass properties:
PropertyOne
PropertyTwo

Some generic code:
myString = "One"
MyClass.Property & myString = "blah" 'this doesn't work

Slai · Accepted Answer · 2017-07-21 01:42:06Z

0

CallByName MyClass, "PropertyOne", vbLet, "blah"

answered Jul 21, 2017 at 1:42

Slai

23k5 gold badges49 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Can I do something like this: CallByName MyClass, Property & myString, vbLet, "blah"

@user5689314 yes but it has to be a string: "Property" & myString