Data=Form can handle 32 columns. Select your 24 columns and then try it
As a test, click in your first description, do Ctrl+Shift+8. Does this just
select your 2 rows and 24 columns. If not, then you need to figure out why
it is picking up a wider region. Your descriptions should be isolated by
either the sheet boundary or a blank column on each side and should be in
row 1 or 2 (again, offset by blank rows or the boundary)
--
Regards,
Tom Ogilvy
Devon T. Sowell wrote in message
...
I have an excel worksheet with 24 columns(descriptions) and 1 row(values).
I'd like to build a Form that would allow data entry for the 24 columns and
create a new row.
Could I please get any tips on how to do this? When I click Data, Form, I
get an error message stating there are too many fields.
2 computers in our office, one with excel 2000, the other with excel 2003.
Thanks in advance,
Devon T. Sowell
www.3-ddesignsolutions.com