adding lines to a line database

i've created a simple data entry form in excel using VBA and as before, i have a few questions. currently, when a "submitt" button is pressed on the form, all the data from the fields is copied to a line database. of course if i want to enter a new line of data, it writes over the existing line. what i would like to know, is there a small bit of code or could someone point me to a helpfull ref so that once the "submitt" button is pushed, the data is copied and the next cell to get data is the row below the last entered. i figure i'd use Select.Cell or something along those lines...

thanks a ton guys...