Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List and Data Form
Robert,
From the main menu: Insert|Name|Define The first row should be the row names. -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "Robert" wrote: I am reading the book Excell 2003 Bible and it says this about lists and Data Forms. "If your list is named Database, Excel automatically extends the range definition to include the new row(s) that you add to the list using the Data Form dialog box. Note that his works only if the list has the name Database; any other name doesn't work." My question is how do you name a list? Thanks... -- Robert Hill |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List and Data Form
I selected my entire list and named it DATABASE and all seems to work fine.
Thanks... -- Robert Hill "Martin Fishlock" wrote: Robert, From the main menu: Insert|Name|Define The first row should be the row names. -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "Robert" wrote: I am reading the book Excell 2003 Bible and it says this about lists and Data Forms. "If your list is named Database, Excel automatically extends the range definition to include the new row(s) that you add to the list using the Data Form dialog box. Note that his works only if the list has the name Database; any other name doesn't work." My question is how do you name a list? Thanks... -- Robert Hill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop-down list on simple excel 2003 form using "form" from data me | Excel Discussion (Misc queries) | |||
create a data list by using a form | Excel Worksheet Functions | |||
Data Entry Form and List | Excel Discussion (Misc queries) | |||
Data entry form - Add to list | Excel Discussion (Misc queries) | |||
How do I get a list of data on one sheet into the form on the fir. | Excel Discussion (Misc queries) |