Userform Help

[Shaknhands]

I've been trying to play around with a userform.

I've created a simple form and on most of the test sheets that I have tried it on it works just fine, places everything where it is supposed to go. When I import the saved form to the main worksheet it is intended for all the entries from the userform are inputted into row 208 instead of the next blank row (row 3 or 4). The only thing that I can think of that is causing the same template to work on one worksheet and not the other is the formatting that I have installed on the intended worksheet.

There are no formulas in the cells that the userform is imputting the data into (probably not getting my wording right, I know) so is there a way around this?

Any help would be appreciated!

[royUK]

Do you mean a WorkBook not a WorkSheet? I don't understand what you mean by importing a form to a worksheet. Formatting of a sheet will not affect data input.

We can't help with code unless we see the code

[Shaknhands]

Here is the code that I am using.

Please Login or Register  to view this content.

[royUK]

You still haven't explained whether you mean import to a different workbook. Your code will only work on a sheet named sheet1,

Please Login or Register  to view this content.