jdub12280
10-28-2009, 02:07 PM
Greetings,
I am in early stages of creating a user form to tally sales results. After reading a few threads here, one by fumei in particular, i've realized I need to break down all my If statements and turn in to a loop. The form contains 7 different frames with anywhere from 3 to 7 items including text and check boxes located next to each other. I have an "add items selected" and a "remove items selected" button on form.
I have so far, named all the check boxes and text boxes, in an easy to understand manner (chkExmpl1 / txtExmpl1, chkExmpl2 / txtExmpl2). I believe somehow the names of these objects needs to be variably linked, so we don't have to reference each one in code. I just don't quite grasp how to accomplish this yet.
I am attaching a sample workbook with the form embedded. I am showing all of my non brilliance, and have texted out an attempted loop statement at the bottom of my code.
Any and all help is greatly appreciated!
Thanks
Justin
I am in early stages of creating a user form to tally sales results. After reading a few threads here, one by fumei in particular, i've realized I need to break down all my If statements and turn in to a loop. The form contains 7 different frames with anywhere from 3 to 7 items including text and check boxes located next to each other. I have an "add items selected" and a "remove items selected" button on form.
I have so far, named all the check boxes and text boxes, in an easy to understand manner (chkExmpl1 / txtExmpl1, chkExmpl2 / txtExmpl2). I believe somehow the names of these objects needs to be variably linked, so we don't have to reference each one in code. I just don't quite grasp how to accomplish this yet.
I am attaching a sample workbook with the form embedded. I am showing all of my non brilliance, and have texted out an attempted loop statement at the bottom of my code.
Any and all help is greatly appreciated!
Thanks
Justin