View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CSUS_CE_Student[_2_] CSUS_CE_Student[_2_] is offline
external usenet poster
 
Posts: 16
Default Sow do i make a userform know if a value is true in a frame, then

I am trying to make a list that will list what catagory and items chosen in
that catagory. For example, Catagory is animals. WHen i generate the list i
want the program to List the Catagory and then list any true (checked)
values in the frame in the userform. If there are no checked boxes then i
want it to skip the output for that frame. I know i can write it like this

Range("A1").select
If cat.value=false and dog.value=false and ... Then
Else

If cat.value=true Then
activecell.value=cat
activecell.offset(1,0).select
End If
If dog.value=true Then
activecell.value=dog
activecell.offset(1,0).select
End If
End If

After this the next frame with a different catagory would go through its code.

Is there any way to shorten the code using a loop or some other method? I
will have close to 100 or more items in the final list and i want to make it
more simple in the code.

Thanks, CSUS_CE_Student