Entering UserForm Data Into a Worksheet

Hello! I need a little help in making an account database.
I made a worksheet wherein the user inputs information such as username, password and id number through text boxes. The worksheet wherein I want the data to appear in is named "Usernames and Passwords". I have a command button (something like submit) and here is my code for it:

Please Login or Register  to view this content.

My problem is that when I enter another set of information, it replaces the one before it, so I'm stuck with just a single row of information. Thank you very much!

To comply with forum rules, you should add code tags to your code excerpt.

However, while you do that and, to save you some time, move the "Dim ctr As Long" above the "Private Sub CommandButton1_Click()"

What's happening is the variable is defined within the module and created afresh every time the button is clicked ... hence you get row 2 every time.

Regards, TMS

Hi

Upload the file....