Help with looping over pre-defined list of objects

[ironfelix717]

Hi,

I am trying to eliminate some of the repetitiveness of my code. I have been reading about loops and arrays but I'm struggling to understand how I loop over a list of pre-defined userform objects.

Here is the basics of my code (not full code)

Please Login or Register  to view this content.

'Userform write values to database:

Please Login or Register  to view this content.

For instance if I use,

Please Login or Register  to view this content.

I would like to just define some kind of list at the get-go of all my controls and their respective offset value. Then I can just loop through the list when I need to execute commands.

I apologize for the noob questions.


Thanks for the help.

[jindon]

Something like this may give you the idea...

Please Login or Register  to view this content.

[ironfelix717]

jindon, thanks,

I could in fact do that, but that only helps me until the order is no longer consecutive. For instance if...

txtbox_location1.value = row 1
txtbox_location2.value = row 2
txtbox_location3.value = row 5
txtbox_location4.value = row 9

Then i am out of luck with this option.

Thanks for your help with this.

[jindon]

Then something like.

Please Login or Register  to view this content.

You could do some other ways using array(s).

[ironfelix717]

jindon,

Thanks for the help. I think i'll stick with the For Loop for now. Its has tidied up my code a lot.