View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Help with data entry form please

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