Add new record to excel userform below the last record

Hi all,

I have a userform that is really handy. The only thing that I would like to add is a button that would bring me to a new row below the last row with data and empty the form so I can add data and save it.
I'm just not able to make this work. I think that the empty form can be omited as when the form goes to the next empty row, there should be no information anyway.

If some one would be able to help out, would be great.

Please find attached the excel userform that I use.

Greetings,
megatronixs

I've added a button Move Down.
Try this:

Hello Stojko89,

Thank you for your help. The button kind of works (I needed to take the End IF at the end of the code). The problem is that if I would be on a different row and I would click on the button, it will just go one row below and not to the next empty row. I guess it should check what is the last row and then one below, but my knoweldge about VBA is not enough to change this.

Maybe you have another idea how to implement this ;-)

Thank a lot for your help.
megatronixs

P.S. can you save the workbook in excel 2003 format as I don't have the newer version :-)

Hello John,

Thanks again for your great help. You really have a great knoweledge about VBA.
Every time I'm working with the userform I discover new things and then I try to add new functionality to improve the user expirience ;-)

Thanks again and have a nice day ;-)

Greetings,
megatronixs

Hi John,

Is there a way that I can protect the sheet and have only the userform make the changes to the cells?
I would like to have some columns protected that only a person can add their user name in the cell, but only via the userform with a button. This way I'm sure they will not be able to enter nothing else. If you have an idea, please let me know.

Thanks in advance,
megatronixs