SiddersAtCHEP
Board Regular
- Joined
- Nov 2, 2005
- Messages
- 104
I have a form which has several textboxes. Depending on choices made in a listbox, I need to fill one, some or all of the textboxes with information. I do not want to have to refer to them as TextBox1, TextBox2 etc. I would prefer to use something like:
for i = 1 to 10
textBox(i) = activecell.value
activecell.offset(1,0).select
next i
In effect I want an array of controls that I can refer to by their index number. I have tried naming the controls TextBox(1) etc. but I keep getting an error when I try this.
Any suggestions?
for i = 1 to 10
textBox(i) = activecell.value
activecell.offset(1,0).select
next i
In effect I want an array of controls that I can refer to by their index number. I have tried naming the controls TextBox(1) etc. but I keep getting an error when I try this.
Any suggestions?