Problem referencing a series of text boxes using the numbers in their names.

I'm fairly new to VBA and I'm building a form that has a large number of text boxes on it designed to show the contents of a 2d array. The boxes are sequentially named a1, a2, a3, etc. To populate those boxes from an array is there a way to reference the name of each box based on an incrementing number rather than write out a large number of a1.Value =, a2.Value =, etc statements?

I tried a loop like this one

for i = 1 to 10

a(i).Value = array(i, 1)

next i

but the a(i).Value syntax is misinterpreted.

I'm probably barking up the wrong tree and there's a better way to do this, any ideas would be appreciated

Assuming you are referring to a userform

Please Login or Register  to view this content.

My pleasure. Please do not forget to mark the thread Solved.