[SOLVED] 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

I guess Data-->Form doesn't work? Just want to make sure you're aware of the
feature.
************
Anne Troy
www.OfficeArticles.com

"Abay" <[email protected]> wrote in message
news:[email protected]...
> 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
>

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" <[email protected]> wrote in message
news:[email protected]...
>I guess Data-->Form doesn't work? Just want to make sure you're aware of
>the feature.
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "Abay" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>
>