I have a userform with a column of textboxes (txtfruit1, 2, 3...10). The
textboxes are populated with different fruit items.

Adjacent to these I have another column of combo boxes which denote the
color of the fruit (cboColor1, 2, 3....10). I use these to select the color
of each fruit with the choices Orange, Green, Yellow or Other.

Adjacent to the combo boxes I have another column of text boxes which have
the quantity of each fruit.

Next to the quantity boxes is an optionbox (OptionBox1, 2, 3....10)

Also on the userform I have 4 textboxes which are for the total number of
each color of fruit (txtOrange, txtGreen, txtYellow and txtOther)

What I need is for code to see which option boxes are checked and totalize
the checked quantities of selected color of fruit into the 4 totalizer
textboxes.

I know this sounds complicated, but can anyone help me?

Best regards,

Roger