Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 694
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop-down list on simple excel 2003 form using "form" from data me S Beals Excel Discussion (Misc queries) 0 March 2nd 10 08:35 PM
create a data list by using a form Record keeping[_2_] Excel Worksheet Functions 0 November 21st 08 04:38 PM
Data Entry Form and List Bethany L Excel Discussion (Misc queries) 0 February 17th 06 04:21 PM
Data entry form - Add to list akid12 Excel Discussion (Misc queries) 1 June 4th 05 01:27 PM
How do I get a list of data on one sheet into the form on the fir. PrestonL Excel Discussion (Misc queries) 0 February 16th 05 09:29 PM


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"