Call different macros using multiple control checkboxes in a userform

Hello All,

I have 12 checkboxes in a userform. I want to be able to select all 12 checkboxes if needed. Based on which chexboxes are selected, I want to call a specific macro. Since I want to be able to select more than one checkbox, I need the code to loop until all cases have been checked and executed. I cannot seem to get the attached code to call the macros. When I run the code, I do not get any errors, but nothing happens. Any ideas?

Please Login or Register  to view this content.

I have an elseIf statement that follows this code, but I figured if I can get this portion to work correctly then I could figure the rest out. I did not feel it was necessary to include all 12 of the checkboxes in the above sample code.

Be gentle, I'm new to VBA.

I'm not very familiar with a listbox. Let me go into more detail of what I'm trying to accomplish and then if you think I would be better off using a listbox I will give it a whirl.

Essentially I have a Userform where I have 4 options (veesel, infuser, blender, pda). Based on which option is selected, the code will then import my data file which is unique to one of the 4 options above. (This part of my code works). Once the file is imported, then the code i previously pasted above is executed when I click a commandbutton (Graph). I will be graphing based on the imported data file up to 12 charts. Some of the Charts will be graphing the same columns of data, but I will only change the title of the worksheet in which the graph is genereated. Based on that criteria, would I be able to reference the title of the worksheet generated when my charts are created i.e. Circulating Rates, Acid, etc to the values in the listbox?

I'm all about keeping it simple, but I'm getting in over my head and have no experience with listboxes. If you think listboxes is the way to go, I will give that a whirl and report back when I have something to show.

Copy 2 of ZZZZZZZ Grapher.xlsm


I imported the data file that I have been experimenting with in the Job Data sheet.

Man... can't thank you enough. I appreciate the help. Sometimes it seems so simple.

I realize that the code is going through multiple iterations, but in the future is there a different approach I can take with the code to speed up the results of the charts?

No, it is working properly. Disregard my last question, and thanks again for the help.