topic Re: in VBA Forum

Array of Controls...

Anonymous — Fri, 17 Aug 2001 04:28:21 GMT

In VB6 I can create an array of controls, like a textbox(0 to 6), but I cant
do that on a vba form...
If I have a group of similar controls (textbox1, textbox2, textbox3) how can
I loop through them
with this type of code:

for x = 1 to 3
var = userform1.textbox(x).value
next

Rodney

Re: Array of Controls...

Anonymous — Fri, 17 Aug 2001 04:59:57 GMT

Hi Rodney

Use the Frame control and place the other controls inside. Then you can loop
through the controls like you want.

Cheers
--
Juerg Menzi
MENZI ENGINEERING GmbH, Switzerland
http://www.menziengineering.ch

"Rodney D. Lester" schrieb:
>
> In VB6 I can create an array of controls, like a textbox(0 to 6), but I cant
> do that on a vba form...
> If I have a group of similar controls (textbox1, textbox2, textbox3) how can
> I loop through them
> with this type of code:
>
> for x = 1 to 3
> var = userform1.textbox(x).value
> next
>
> Rodney

Re:

Anonymous — Fri, 17 Aug 2001 07:29:54 GMT

The controls are in a frame... What is the code to loop through them...
My sample code does not work...

Rodney

"Jürg Menzi" wrote in message
news:3B7D154D.38D7825D@bluewin.ch...
> Hi Rodney
>
> Use the Frame control and place the other controls inside. Then you can
loop
> through the controls like you want.
>
> Cheers
> --
> Juerg Menzi
> MENZI ENGINEERING GmbH, Switzerland
> http://www.menziengineering.ch
>
>
> "Rodney D. Lester" schrieb:
> >
> > In VB6 I can create an array of controls, like a textbox(0 to 6), but I
cant
> > do that on a vba form...
> > If I have a group of similar controls (textbox1, textbox2, textbox3) how
can
> > I loop through them
> > with this type of code:
> >
> > for x = 1 to 3
> > var = userform1.textbox(x).value
> > next
> >
> > Rodney

Re:

Anonymous — Fri, 17 Aug 2001 07:46:09 GMT

Hi Rodney

For x = 0 to (NumberOfControls -1)
Var = FrameName(x).Value
Next x

That's it...

Cheers
--
Juerg Menzi
MENZI ENGINEERING GmbH, Switzerland
http://www.menziengineering.ch

"Rodney D. Lester" schrieb:
>
> The controls are in a frame... What is the code to loop through them...
> My sample code does not work...

Re:

Anonymous — Fri, 17 Aug 2001 08:42:29 GMT

How do I know which control I am getting with the X index?

Rodney

"Jürg Menzi" wrote in message
news:3B7D3C41.19893C06@bluewin.ch...
> Hi Rodney
>
> For x = 0 to (NumberOfControls -1)
> Var = FrameName(x).Value
> Next x
>
> That's it...
>
> Cheers
> --
> Juerg Menzi
> MENZI ENGINEERING GmbH, Switzerland
> http://www.menziengineering.ch
>
>
> "Rodney D. Lester" schrieb:
> >
> > The controls are in a frame... What is the code to loop through them...
> > My sample code does not work...

Re: Array of Controls...

Anonymous — Fri, 17 Aug 2001 12:06:24 GMT

Randal Rath at VbDesign has a routine that works by assigning the 'index number'
to the control's tag property. Then you can loop through the controls and check
the 'tag' value to know which control it is working on. Silly that vba does not
support control arrays.
Go to his web site and look around, the routine is there somewhere.

Tom

"Rodney D. Lester" wrote:

> In VB6 I can create an array of controls, like a textbox(0 to 6), but I cant
> do that on a vba form...
> If I have a group of similar controls (textbox1, textbox2, textbox3) how can
> I loop through them
> with this type of code:
>
> for x = 1 to 3
> var = userform1.textbox(x).value
> next
>
> Rodney