next available row coding issue

Hi All

I know there are a number of posts on this, but I can not see where this is going wrong. I have tried numerous bits of code but nothing seems to work. I know it must be simple (for someone who really knows what they are doing..... which is not me!).

I just want to save contents of userform in next available line in worksheet "UserFormDataEntry". Currently it just keeps saving to active worksheet.

Any help is GREATLY APPRECIATED

Thanks

Please Login or Register  to view this content.

Can you also attach the sheet you are using?

What is Input1, Input2, etc? The names of the text boxes?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

You have no worksheet reference here, so Rng will be referring to A2 on the active sheet.

Please Login or Register  to view this content.

Try adding a reference to the appropriate sheet.

Textboxes contain text values, so to add there values arithmetically you need to convert the text to numbers.

There are various conversion functions you can use, eg CLng, CInt, Val etc

In this case I think CLng might be what you want, that will convert to Long which is the same data type as the variable you want to store the result in.

By the way, you could considerably shorten the first code you posted using loops and the Controls collection of the userform.