Move userform TextBox entries to cells on a sheet

My question is simple. I have a CommandButton on a worksheet named 'Workup' that, when clicked, presents a userform with 15 textboxes (TextBox1 through TextBox15). I have CommandButton1 on the userform also. When I click CommandButton1, I want the value in the textboxes to be placed in cell A1 thru A15 on the sheet named 'Invoice". I think it's just a repeat of the same line of code for each of the 15 TextBoxes. Once the cells on the sheet 'Invoice' are populated, I want to print the sheet 'Invoice' on the default printer. Then, return to the original sheet named 'Workup' and close the userform. The reason I'm using a userform is because the CommandButton does several other things also. Thanks in advance.

Without seeing your workbook and knowing where you are storing values, how about this sample. Place the code behind the form.

Please Login or Register  to view this content.

No problem, I don't see your workbook.

Try this...

No problem.

Replace the code with this new one.

I update the first four textboxes and I'm sure you could fix the rest.

The code uses the .Cells(1,1) notation which is R1C1. Starting in A1 click and hold while you drag the mouse to the location of the input cell. For the fist textbox I would start in A1 and drag to D3 and then look directly above colum A and it should read 3R x 4C.

Therefore;

Please Login or Register  to view this content.

Please Login or Register  to view this content.

That is not a problem

Example

Please Login or Register  to view this content.