Selecting Certain Userform Controls
Yes, you can do that. In the code that follows, just replace the Debug.Print
statement with the code you want to execute for each of the controls on the
specified page...
Dim C As Control
Dim PageToLoopThru As Long
' Remember, pages are numbered starting at zero, so this
' line will select the THIRD tab on the MultiPage for the loop
PageToLoopThru = 2
For Each C In MultiPage1.Pages(PageToLoopThru).Controls
Debug.Print C.Name
Next
--
Rick (MVP - Excel)
"JeremyJ" wrote in message
...
Is it possible to loop through only the controls on a specific page of a
multipage?
|