Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2000 - Column labels for forms
Hello .. I am trying to set up a form for data entry which will use Column
labels as field names for data entry on a form. I used the "Label" option on the forms tool bar with no success, I also tried just entering the field name as the first entry in each column and that doesn't work either. The error message states to use a text label at the top of each column, & that is what I thought I did, but Excel doesn't like it. Tried the help function in Excel with no success. Any help would be much appreciated by this more or less newbie. Abay |
#2
|
|||
|
|||
I guess Data--Form doesn't work? Just want to make sure you're aware of the
feature. ************ Anne Troy www.OfficeArticles.com "Abay" wrote in message ... Hello .. I am trying to set up a form for data entry which will use Column labels as field names for data entry on a form. I used the "Label" option on the forms tool bar with no success, I also tried just entering the field name as the first entry in each column and that doesn't work either. The error message states to use a text label at the top of each column, & that is what I thought I did, but Excel doesn't like it. Tried the help function in Excel with no success. Any help would be much appreciated by this more or less newbie. Abay |
#3
|
|||
|
|||
Yes that is what I am doing, and it gives a message asking about column
headings, which I have set up, but the headings apparently should be "text labels" .. It would be nice not to have this message pop up each time .. I am passing this form on for someone to use it as a data entry tool. Abay "Anne Troy" wrote in message ... I guess Data--Form doesn't work? Just want to make sure you're aware of the feature. ************ Anne Troy www.OfficeArticles.com "Abay" wrote in message ... Hello .. I am trying to set up a form for data entry which will use Column labels as field names for data entry on a form. I used the "Label" option on the forms tool bar with no success, I also tried just entering the field name as the first entry in each column and that doesn't work either. The error message states to use a text label at the top of each column, & that is what I thought I did, but Excel doesn't like it. Tried the help function in Excel with no success. Any help would be much appreciated by this more or less newbie. Abay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make all numbers in a column negative in excel 2000? | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |