Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
parent/child relationship between rows? | Excel Worksheet Functions | |||
Creating child worksheet from parent | Excel Worksheet Functions | |||
Parent of the embeded excel | Excel Discussion (Misc queries) | |||
Sorting Parent Child | Excel Worksheet Functions | |||
A parent spreedsheet problem | Excel Discussion (Misc queries) |