excel - Counting Checkboxes on a page of a multipage userforms -
I am trying to measure the number of check boxes that are checked on a specific page of the user. I'm using VBA with Excel 2010
This is my code:.
Public CT AutoCount () dimmed the CTL control till J. CharacterBuilder.MultiPage1 for each CTL as .ages (2) .Controls' error was here typeof CTL msforms.CheckBox then CharacterBuilder.Controls (ctl.name) .Value = True, then j = j + 1 end if end is the next CharacterBuilder.Remaining.Caption = j, then CharacterBuilder.Skills Unload 'are not sure what it does End Sub
I get a run-time error 459 object or does not support the set of classroom events.
After this Therefore, the second page will be Your code should work. with a special MultiPage
control That is, unlike most things VBA, their index is 0-based. Pages (1)
and not Pages (2)
, since page (0)
The first / default page is that you change your error line to the following:
CharacterBuilder.MultiPage1.Pages (1) for each CTL (1) .Controls
Comments
Post a Comment