Adding data via aUser Form

[makku]

Hi,

I trying to create a user form whereby, the user inputs data in an Excel form and when clicking the Add button, the data in the form is stored in a worksheet.

I have the following code (tried to adapt it from an online source) however it is not working... once i click on the command button nothing happens!

Here is the code:

------------------------------------------

Please Login or Register  to view this content.

------------------------------------------

Can anyone help please?


regards,

[Whizbang]

Please wrap your code in code tags, as per the forum rules. This makes the code easier to read by preserving tabs and spacing. For more information on how to use code tages, please see the Forum Rules linked at the top of the page.

Try

Please Login or Register  to view this content.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[makku]

Thanks, it worked.

[royUK]

Now add the code tags