Saving textbox data from a userform to Sheet2 cells...

I have a macro that formats "Sheet2" from data in Sheet1 and then launches a user form (UserForm1). From UserForm1 there are (4) textboxes and each one of these text boxes would need to save the data within either 3 or 4 times each. TextBox1 and TextBox2 would need to be saved (4) times. TextBox3 and TextBox4 would need to saved (3) times into the respective cells in Sheet2.

i.e.
PCRLocation - PCR1 (saved 4 times F2:F5)
PCR Plate ID - 119416 (saved 4 times G2:G5)
Source ID - J93174_001 (saved 3 times H2:H4)
DNASource ID - DNA1 (saved 3 times J2:J4)

I have been able to code it to save to the correct cells, but not in replicates. Does anyone know how to approach this?? I cannot seem to get this to work at all.

Currently the code for UserForm1 is as shown below:

Please Login or Register  to view this content.

Second question, right now there is no code to decifer if the text boxes are filled with data out of the order listed on Sheet2, but if there is a way to associate the text box data with a specific common name so the save starts at the right row that would be ideal. Currently the saves start at Row2 ColumnF (first empty cell). The ideal would be if a user wants to start with lets say PCR Location (PCR4) they could and the macro would know to start with that row (line 14 on Sheet2) from Sheet2 for saving those records.

Is it possible to code the macro to save with row association? If so please help.

Thanks in advance,

J.

pay Your attention on this part

Please Login or Register  to view this content.

Let's say irow=3, so if you want to save value of TextBox1 into cells "H3:J3" you can use this

Please Login or Register  to view this content.

and for rows offset

Please Login or Register  to view this content.

so try update your code in this way

Please Login or Register  to view this content.