Attachment 475265

Basically it is for X-bar & R-bar Chart which elloborates a thickness of a component measurement.

1. There are Three Measurement in single Component
2. Five Components to be checked in a sample
3. Three samples should be checked in a both shift
4. There are 2 Shifts Running currently(so totally 90 Measurements)

My problem is that i have two combo boxes in the userform1
Combobox1 = Shift 1 and Shift 2
Combobox2 = Sample1, Sample2, Sample3
Userform1 takes the input of three measurement of each five components(Which named as sample1)
Now i want to do the same for Sample2 and sample3 for 1st Shift and
Sample1,Sample2,Sample3 for 2nd Shift and again for next day and store the Measurements

I was not able change the Shift and Samples in the Combobox even for the 1st day. Your Help will be greatly appreciated. Thanks in advance