RD4 Posted July 28, 2016 Share Posted July 28, 2016 Hi, Is it possible to access property of the object using variable, for example I have the object named "objExample" with properties named: Property1 Property2 Property3 Property4 ... Property10 I would like to access all of these properties in FOR loop using variable propertyName = " Property " & i in each step, but I don't know how to make it. The code below it's an simple example of my problem ("???" indicates piece of code which I missing): Dim i Dim propertyName Dim objExample Set objExample = ....... For i = 1 To 10 propertyName = " Property " & i objExample.??? = ...... ...... Next Best regards Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now