Jump to content

Property defined by variable


Recommended Posts



Is it possible to access property of the object using variable, for example I have the object named "objExample" with properties named:









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.??? = ......




Best regards

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...