Help with data entry form please

  • Thread starter Thread starter Devon T. Sowell
  • Start date Start date
D

Devon T. Sowell

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
 
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

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
 
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
 
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-us/dnoffpro01/html/IntroductiontoUserFo
rmsPartI.asp
Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFo
rmsPartII.asp
 
Tom, you're a great help.

Thank you,
Devon
Tom Ogilvy said:
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-us/dnoffpro01/html/IntroductiontoUserFo
rmsPartI.asp
Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFo
rmsPartII.asp


--
Regards,
Tom Ogilvy


into try Form,
Click to expand...
 
Back
Top