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

**nm766** · 01-29-2011, 10:53 PM

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

**jaslake** · 01-29-2011, 11:37 PM

Hi nm766

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

A sample of what you have, with the UserForm and the code behind it, will be very helpful. Please include an "after" worksheet in your sample.

**nm766** · 02-07-2011, 12:43 PM

Dear friends,

I am having problem of transfering few data columns of a work sheet to another in the same work book. Problem is few columnsae haning calculation formulas. For ex:= If I require to transfer the cell values of A2 to F67and againN2 to Q67 and againR2 to R67,of Work Sheet 'A' to WorkSheet 'B' How the code be written. I do not want to manually copy and Paste special the required range of cells. It shoule run automatically.

hanks