Hi,

i am trying to prepare data entry form in excel. I have 25 check boxes in the userform for which i have allocated 25 columns(Range A:Y) in excel. If the user1 selects checkbox 1,3,14,18,20,25 then after pressing submit button on the form data should be stored in excel sheet at following locations.

A1 should contain code 1
B1 should contain code 3
C1 should contain code 14
D1 should contain code 18
E1 should contain code 20
F1 should contain code 25

Also if the User2 select checkbox 3,7,12,17,19,21.15 then after pressing submit button on the form data should be stored in excel sheet at following locations.

A2 should contain code 3
B2 should contain code 7
C2 should contain code 12
D2 should contain code 19
E2 should contain code 21
F2 should contain code 15

Requestv you to help on the above query.

Regards,
Jeetesh