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

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

score 0 · Accepted Answer · answered Jul 21 '17 at 01:42

0

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

answered Jul 21 '17 at 01:42

Slai

Can I do something like this: CallByName MyClass, Property & myString, vbLet, "blah" – user5689314 Jul 21 '17 at 01:48
@user5689314 yes but it has to be a string: `"Property" & myString` – Slai Jul 21 '17 at 01:53

1 Answers1