Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
Photo

Excel controls


  • Please log in to reply

#1
Driest

Driest

    New Member

  • Member
  • Pip
  • 7 posts
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
  • 0

Advertisements







Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP