Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry Form
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry Form
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry Form
Now do I have to run that each time I want to add another 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry Form
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry Form
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry Form
Thanks for jumping in.
Some other part of my life intruded on my time. You didn't know I had a "some other part" did you<g On Tue, 27 Feb 2007 15:27:44 -0600, Dave Peterson wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry Form
Something to do with Word or PPT??? <vbg
Gord Dibben wrote: Thanks for jumping in. Some other part of my life intruded on my time. You didn't know I had a "some other part" did you<g On Tue, 27 Feb 2007 15:27:44 -0600, Dave Peterson wrote: 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry Form
Can this data form be called via a macro, all i get is run time error 1004
"Dave Peterson" wrote: Something to do with Word or PPT??? <vbg Gord Dibben wrote: Thanks for jumping in. Some other part of my life intruded on my time. You didn't know I had a "some other part" did you<g On Tue, 27 Feb 2007 15:27:44 -0600, Dave Peterson wrote: 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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry Form
Maybe...
http://support.microsoft.com/default...;en-us;Q110462 ShowDataForm Method Fails If Data Can't Be Found You can use code like this if you know (or can determine) the range: Option Explicit Sub testme01() Dim LastRow as Long Application.DisplayAlerts = False With activesheet lastrow = .cells(.rows.count,"A").end(xlup).row .Range("A4:x" & lastrow).Name = "'" & .Name & "'!database" .ShowDataForm End With Application.DisplayAlerts = True End Sub I started in A4 until the last used row in column A, then extended it to columns A:X of those rows. Blenkey wrote: Can this data form be called via a macro, all i get is run time error 1004 "Dave Peterson" wrote: Something to do with Word or PPT??? <vbg Gord Dibben wrote: Thanks for jumping in. Some other part of my life intruded on my time. You didn't know I had a "some other part" did you<g On Tue, 27 Feb 2007 15:27:44 -0600, Dave Peterson wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Entry Form | Excel Worksheet Functions | |||
Data Entry Form and List | Excel Discussion (Misc queries) | |||
a data entry form with combo box | Excel Discussion (Misc queries) | |||
Data entry form - Add to list | Excel Discussion (Misc queries) | |||
data entry form | Excel Discussion (Misc queries) |