IF Statement loop

[pkling]

Hi,

I have a userform with 16 rows of 5 textboxes which can be filled in. What I need is the code to do an if statement (or something similar) to check whether the first textbox in the row is filled in and if it is the data in that row is copied to the data sheet and so on. But if textbox 1 in row 3 (for example) is not filled in do not copy but check the following rows and copy where necessary.

Thank you in advance.

Question can also be found here:
http://www.mrexcel.com/forum/showthread.php?t=465815