Jump to content

Property defined by variable


RD4

Recommended Posts

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

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