MrExcel Publishing
Your One Stop for Excel Tips & Solutions

adding lines to a line database


Posted by Josh on December 12, 2001 3:37 PM

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...


Posted by Joe Was on December 12, 2001 4:34 PM

Without seeing your code it is hard to do, but if you want to play with your code. Near the bottom you should have some code to place the selection on your row. Add OffSet(1,0) to the code on that line.

like: Selection.OffSet(1,0)=myVar

JSW