You can add as many more rows as you want without dismissing that dialog. But
if you close that dialog, then decide you want to add more, you'll have to
reshow the dialog.



Brian T wrote:

Do I have to run that each time I want to add a record or will it stay

"Gord Dibben" wrote:

Brian

Excel already has a data form under DataForm.

New entries are placed at the end of a list.

Basics..................

1. Type labels in A1:C1 First, Last, Date

2. Select A1 and DataForm. Click OK when asked if you want to use row 1 as
labels.

Start entering data.


Gord Dibben MS Excel MVP

On Tue, 27 Feb 2007 12:20:08 -0800, Brian T
wrote:

I want to create a data entry form that will put the new data at the end of a
list. The form would include first and last names, and few dates. Any ideas



--

Dave Peterson