Help with code to have database userform add values to next empty row.

[dcgrove]

Go easy on me, this is the very first userform and vba project I have written on my own. How do I write the code so that when the add button is clicked it adds the values in the form to the next empty row. Right now it just owerwrites the values in row 2.

Please Login or Register  to view this content.

[dominicb]

Good evening dcgrove

Have a look at the attached workbook.
It shows a simple address book driven via a userform, and identifies the next available row for each line of data posted.

HTH

DominicB

[dcgrove]

That was exactly what I needed. For future reference this is what my code looks like now.

Please Login or Register  to view this content.

thanks!