Help with data entry form please
 

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

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

Help with data entry form please
 

Thanks for the reply, Tom.

Of course, I had made a mistake, there are actually 50 columns, not 24.
Sorry about that.

So, when I select 32 or less columns, then I can use the Data Form. Thank
you.

Can I build a User Form in VBA that can enter data for all 50 columns into a
new row?
I'm a rookie when it comes to using VBA, I've just created a few simple
macros.

Thank you,
Devon T. Sowell
www.3-ddesignsolutions.com

"Tom Ogilvy" wrote in message
...
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

Help with data entry form please
 

first, John Walkenbach has a more robust Form addin (it says it doesn't have
a column limitation). The addin itself is free, but if you want access to
the sourcecode I believe there is a fee.

http://j-walk.com/ss/dataform/index.htm

But if you want to role your own:
Sure you can. Here is a starter article:

http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data

A tutorial:

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.


some more indepth resources but more general:

http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"

Microsoft(R) Visual Basic(R) for Applications Examples for Controlling
UserForms in Microsoft Excel 97

This Application Note is an introduction to manipulating UserForms in
Microsoft Excel 97. It includes examples and Microsoft Visual Basic for
Applications macros that show you how to take advantage of the capabilities
of UserForms and use each of the ActiveX controls that are available for
UserForms

Peter Aiken Articles:

watch word wrap. the URL should all be one line.
Part I
http://msdn.microsoft.com/library/en...uctiontoUserFo
rmsPartI.asp
Part II
http://msdn.microsoft.com/library/en...uctiontoUserFo
rmsPartII.asp


--
Regards,
Tom Ogilvy


Devon T. Sowell wrote in message
...
Thanks for the reply, Tom.

Of course, I had made a mistake, there are actually 50 columns, not 24.
Sorry about that.

So, when I select 32 or less columns, then I can use the Data Form. Thank
you.

Can I build a User Form in VBA that can enter data for all 50 columns into
a
new row?
I'm a rookie when it comes to using VBA, I've just created a few simple
macros.

Thank you,
Devon T. Sowell
www.3-ddesignsolutions.com

"Tom Ogilvy" wrote in message
...
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

Help with data entry form please
 

Tom, you're a great help.

Thank you,
Devon
"Tom Ogilvy" wrote in message
...
first, John Walkenbach has a more robust Form addin (it says it doesn't
have
a column limitation). The addin itself is free, but if you want access to
the sourcecode I believe there is a fee.

http://j-walk.com/ss/dataform/index.htm

But if you want to role your own:
Sure you can. Here is a starter article:

http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data

A tutorial:

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.


some more indepth resources but more general:

http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"

Microsoft(R) Visual Basic(R) for Applications Examples for Controlling
UserForms in Microsoft Excel 97

This Application Note is an introduction to manipulating UserForms in
Microsoft Excel 97. It includes examples and Microsoft Visual Basic for
Applications macros that show you how to take advantage of the
capabilities
of UserForms and use each of the ActiveX controls that are available for
UserForms

Peter Aiken Articles:

watch word wrap. the URL should all be one line.
Part I

http://msdn.microsoft.com/library/en...uctiontoUserFo
rmsPartI.asp
Part II

http://msdn.microsoft.com/library/en...uctiontoUserFo
rmsPartII.asp


--
Regards,
Tom Ogilvy


Devon T. Sowell wrote in message
...
Thanks for the reply, Tom.

Of course, I had made a mistake, there are actually 50 columns, not 24.
Sorry about that.

So, when I select 32 or less columns, then I can use the Data Form.
Thank
you.

Can I build a User Form in VBA that can enter data for all 50 columns
into
a
new row?
I'm a rookie when it comes to using VBA, I've just created a few simple
macros.

Thank you,
Devon T. Sowell
www.3-ddesignsolutions.com

"Tom Ogilvy" wrote in message
...
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