Transfer data from userform to a sheet

Hi guys.

I have a userform where I can enter the data, what I would like to achieve is when the button is pressed the vba transfers data from userform to a sheet.

My main problem is that there are three fields "part number" "description" and "qty" in userform which have to be filled in by the ops and each of these fields contain 6 textboxes(in future I would like to add more textboxes). Other fields that need to be filled in are "time", "unique operator", "vendor" and others, each of them have only one textbox per field.

Would it be possible, lets say if "part number" "description" and "qty" are filled in, transfer them to a sheet together with the other fields and copy fields like "time", "unique operator", "vendor" as many times as the main records were copied.

Hopefully that make sense, I have also attached the sheet for a reference.

I would really appreciate any help.

Thanks in advance

Hi,

I'm confused.

Originally I thought this was a data collection task using a form to enter a new order number and the other 3 pieces of information Operator, Job Type & Vendor, plus 1-6 sets of information re Part Number Description & Quantity.

However the Search button populates all these fields when an existing order number is entered which rather suggests it's not about capturing new data, rather identifying and perhaps editing existing data records.

Please clarify.

Hi,

One way

Please Login or Register  to view this content.