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.

itemprop = "text">

After this with a special MultiPage control That is, unlike most things VBA, their index is 0-based.

Therefore, the second page will be 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  

Your code should work.


Comments

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

java - Gradle dependencies: compile project by relative path -

ruby on rails - Object doesn't support #inspect when used with .include -