Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  ASP.NET  VB.net excel controls

Author  Topic  Driest Starting Member 3 Posts Posted - 2006-01-26 : 14:04:22 I have a custom excel form and a list of checkboxes inside the form. When checked, it will print a particular table on one page. I also have a button to print the entire booklet at once. This will cycle through all controls and check them if they are a checkbox. The problem is it seems to do so in a random manner. The code for the buttonn pressed is as follows: Private Sub cmdBooklet_Click() Dim pPage As Page Dim cCont As Control For Each pPage In MultiPage1.Pages For Each cCont In pPage.Controls If TypeName(cCont) = "CheckBox" Then cCont.Value = True End If Next cCont Next pPage End Sub Is there a way i can loop through the controls in a particular order? The tab order doesn't seem to do much. Thanks for your help