Loop through checkboxes within specified frame.

[Paella1]

Is it possible to distinguish a checkbox that is inside a frame from one that is outside it? What I am trying to do is loop through all the checkboxes on a multipage but only those that are within a specified frame.

 

[Leith Ross]

Hello Paol,

Here is one way if you know the name of the frame on the multipage. This example checks Frame1 on Page 1 of the object Multipage1.

 Dim Ctrl As Control
 
  For Each Ctrl In Me.MultiPage1(0).Controls("Frame1").Controls
    If TypeName(Ctrl) = "CheckBox" Then
       X = Ctrl.Name
    End If
  Next Ctrl

Sincerely,
Leith Ross

 

[Paella1]

Leith,
Apologies for the late response, I was distracted by less important things.
It works a treat. Many thanks.
Paul

 

[bolo]

Hi, sorry to dig up an old thread, but what if you do not know the name of the frame? I am facing a similar problem, but because i have dynamically created the frame, i have a whole host of frames to go through. How would i do this?

Thanks

Bolo

 

[mikerickson]

If you know the checkbox, CheckBox1.Parent is the frame, page or userform that it is contained in. Perhaps something like

Dim knownBox as msForms.CheckBox
Dim Container as Object
Dim oneControl as Object

Set knownBox = Userform1.CheckBox23

For Each oneControl in KnownBox.Parent.Controls
    If TypeName(oneControl) = "CheckBox" Then
        MsgBox oneControl.Name & IIf(oneControl.Value, " is ", " is not ") & " checked."
    End If
Next