What is OCMC? If it is a reference to your multipage object, the code will
not work. If it is a reference to your userform, it should work because the
controls in the multipage are still considered to have the form as their
parent object.

--
John Green
Sydney
Australia


"John Wilson" wrote in message
...
Due to screen space limitations I had to move a group of CheckBoxes
from MY UserForm onto a MultiPage on that UserForm.

The code that I used to extract info from the CheckBoxes is as follows:

Dim ctl As Control
For Each ctl In OCMC.Controls
If TypeName(ctl) = "CheckBox" Then
If ctl.Value = True Then
cbResult = cbResult & VBA.Left(ctl.Caption, 3)
End If
End If
Next ctl

Been trying, but can't seem to modify this to work with the CheckBoxes
on the MultiPage Control (there are three pages on the multipage and I'd
like to address all of them).

Any ideas?

Thanks,
John