Transfer User form data to a worksheet w.r.t. combobox item on the form

[nm766]

Dear Sir and all my friends,
I have a problem of transfering data from a user form to a predefined worksheet whrere the data should get stored serially as per the items selected from the combobox on the user form. I am very new to excel and do not know much about excel vb programming. I have 65 items listed in the combobox and it is the 1st control to be selected on the user form while feeding data. Secondly I need to start with the 4th row in the worksheet to store the data for 1st item in the combo list. It should be such that the 1st item data on the user form will get stored in 4th row, the 2nd item in the 5th row and so on till 65th item. And the rows should be fixed for these items. Means when I feed the data for 1st item it should go to 1st row only. If a sample example(showing four to five data input text boxes with combo box list of 65 items (items like AS001,AS002 AB210....not fixed serially but limited to 65 items) data input with code can be replied, It will be of immense help to me.

Secondly, I want to have a time data to be displayed back on the user form in the same format as displayed in the worksheet. I have three text boxes on the user form that give the input to the predefined worksheet the time value. These are calculated in the sheet and stored in a cell that displays the required time data. That data I want to display back while saving the userform input to the worksheet. Example : On the User form X, Text Box 1, 2, and 3 are fed with time (as text) like 456:25, 25:00, 564:33 etc respectively and even sometimes 00:00. When transfered to worksheet Y, they are conditionally calculated and the result is stored in Cell say F2 for first row data. I have a text box on the user form to display thedata stored in F2 in the same format. The time format of the cell F2 is (37:30:55 pattern) I have tried and the data is getting displayed but in a format like 23.4444444 or when I change the value showing 15.33333333444 etc. So how can it be displayed in the same format as in the F2 cell. Note that Full F2 column will be holding the result when I feed the other rows.

Thanking you


Regards,

nm766