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

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

Graciemygirl wrote:

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

--

Dave Peterson

32

--
Regards,

Peo Sjoblom

Portland, Oregon




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

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.



http://www.geocities.com/excelmarksway


"Graciemygirl" wrote:

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