Adding rows with every login

Hi Guys,

I have just started learning Excel Programming and created an userform in which you can enter name and once you click submit. the username and date and time are entered in a relevant row.

I am unable to add new rows, to be honest I have no clue how to do that as today is the first time I am doing VBA.

Can anyone let me know how to do it, pasted below is the Code for submit command button

Code:

Please Login or Register  to view this content.

Regards,

Veejar

Try

Please Login or Register  to view this content.

Try this,

Please Login or Register  to view this content.

Or that

Thanks a lot guys that really works cool.

But I have a few more doubts.

What I want is that when a user tries to open the workbook then excel should always show sheet named "Login History" and the login userform should open and then the user will prompted to enter password in password form.

The password entered has to be hidden as in say for example password is X01 then it should display *** while the password is being entered.

Once password is entered and user clicks on the submit command button in password fom then the macro has to check the password entered with the corresponding username as mentioned in sheet named "IDs"

Once password is verified then the login data should be added to the next row in sheet named "Login History" and not in any other sheet.

That would be for another thread, You can mark this thread as solve, give the reputation to whoever you want and then start a new thread with a new question.

If you do a search (Advanced) on my name you will find a login form example