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 |
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 |