View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PaulW PaulW is offline
external usenet poster
 
Posts: 130
Default Counting/Changing multiple buttons?

I'm making a userform, and with each userform everything gets more complete
with more options.

An example was a recent one with 21 togglebuttons.

What i'm wanting to be able to do is to easy change all the togglebuttons to
FALSE, or count how many are on true.
To switch them all i've had to put a line of code for each, setting them to
false individually.
To count them all I've had to set a variable, and check each one
individually, and if its TRUE add 1 to the variable.

Is there a simple way to either use a global command to change/count every
togglebutton, or a simple way to loop through them all?

sub change()
for each togglebox in userform
let value = false
next
end sub

sub change()
for i = 1 to 21
let togglebox & i value = false
next
end sub

Are a couple of things I tried unsuccessfully...