asked on

Using For Each VB 2008

I am trying to loop through a form that has multiple splitcontainers, comboboxes and grids (FPSpread).

I only want to loop through the grids.

How do I do this?

Dim cnt As FarPoint.Win.Spread.FpSpread

For Each cnt In Me.Controls

Thanks

djon2003

In the For each loop.. check for the type of control you have..

So :
Dim cnt As Control

For Each cnt In Me.Controls
If TypeOf cnt Is FarPoint.Win.Spread.FpSpread Then
'' DO SOMETHING
End If
Next Each

Sheritlw

ASKER

I have probably 30 grids on the form. I need to get the controls name, activesheet, etc.. while looping through so I need to reference the control type as a spread so I don't get errors when trying to loop through them.
The grid has different properties etc. than regular controls.
thanks

djon2003

Just cast the control found to your class type..

Dim cnt As Control

For Each cnt In Me.Controls
If TypeOf cnt Is FarPoint.Win.Spread.FpSpread Then
Dim curGrid As FarPoint.Win.Spread.FpSpread = cnt
'' DO SOMETHING
End If
Next Each

Sheritlw

ASKER

Unfortunetly it's not finding the grids. I think it's because my form has a tabcontrol with multiple tabs and a SplitContainer. All the grids are on the splitcontainers.
How do I reference all the splitcontainers and grids?
Thanks

ASKER CERTIFIED SOLUTION

djon2003

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Mike Tomlinson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial