Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sow do i make a userform know if a value is true in a frame, then
Not being able to see everything, and not knowing if your checkbox names are
actually as you've described them here, I'll take a stab at it anyhow. This assumes that the control names are in the Caption portion of the checkbox. In other words you have checkboxs that appear as the box with text like "Dog" or "Cat" or "Horse" displayed. You have a button on the form Named ShowTrueSelections - will probably have several sections of code similar to this, one for each grouping. I'm just having hard time picturing how your form is set up. Maybe this will at least give you some ideas on how to attack it. Private Sub ShowTrueSelections_Click() Dim ctl As Control Range("A1").Select For Each ctl In Me.Controls If TypeName(ctl) = "CheckBox" And ctl = True Then ActiveCell = ctl.Caption ActiveCell.Offset(1, 0).Activate End If Next End Sub "CSUS_CE_Student" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i make a button from a userform exit onto the document in . | New Users to Excel | |||
How to make userform work publically with hidden sheets? | Excel Discussion (Misc queries) | |||
How can I make an excel cell equal to the value of a frame object text box | Excel Worksheet Functions | |||
How to attach legend frame to chart frame? | Charts and Charting in Excel | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |