i have a userform with 10 checkboxes that define packaging. i have a worksheet the with a lot of packaging data on in. At any time I could have as many as three of these boxes check (most of the time just one is check). When the boxes are checked is there a way that i can get those results to display in my worksheet in cells B2, C2, and D2.
For example on my userform i might have checked, Packaging 1, Packaging 2, and Packaging 8 and when I click next or add cmd button I want it to add the results to that range of cells (b2-d2).
If this is not feasible or someone has a better idea, I'll take suggestions.
For example on my userform i might have checked, Packaging 1, Packaging 2, and Packaging 8 and when I click next or add cmd button I want it to add the results to that range of cells (b2-d2).
If this is not feasible or someone has a better idea, I'll take suggestions.