G
Graciemygirl
I am trying to set up a form and I get an error message that reads "too many
fields in data form"
any suggestions???
Angie
fields in data form"
any suggestions???
Angie
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How many fields can you have in an EXCEL form? Is there a limit?
D
Dave Peterson
32.
You may want to look at John Walkenbach's enhanced dataform:
http://j-walk.com/ss/dataform/index.htm
and a short comparison:
http://j-walk.com/ss/dataform/features.htm
And if you want to create your own, then Debra Dalgleish has a get started with
userforms:
http://contextures.com/xlUserForm01.html
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
You may want to look at John Walkenbach's enhanced dataform:
http://j-walk.com/ss/dataform/index.htm
and a short comparison:
http://j-walk.com/ss/dataform/features.htm
And if you want to create your own, then Debra Dalgleish has a get started with
userforms:
http://contextures.com/xlUserForm01.html
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
P
Peo Sjoblom
32
--
Regards,
Peo Sjoblom
Portland, Oregon
--
Regards,
Peo Sjoblom
Portland, Oregon
E
exceluserforeman
hello,
Add another userform or two and share the "fields" between them.
Set it up like a Wizard.
Page 1 is the main form, page 2 is the next form etc.
You could include back buttons and forward buttons and cancel buttons.
Alternatively, use a multipage.
Also, rather than option buttons, use a listbox.
Just of interest, How many fields are you trying to use?
- -Mark
If you are still have problems, send me the workbook and maybe I can create
a wizard-type for you.
[email protected]
http://www.geocities.com/excelmarksway
Add another userform or two and share the "fields" between them.
Set it up like a Wizard.
Page 1 is the main form, page 2 is the next form etc.
You could include back buttons and forward buttons and cancel buttons.
Alternatively, use a multipage.
Also, rather than option buttons, use a listbox.
Just of interest, How many fields are you trying to use?
- -Mark
If you are still have problems, send me the workbook and maybe I can create
a wizard-type for you.
[email protected]
http://www.geocities.com/excelmarksway