software

Hi all. Trying to create a data input form in Excel, with over 40 fields.
The built-in form on the data menu allows only 32 columns of data. Is it
possible to create a bespoke form in Excel or Word to generate more than 32?

You may want to look at John Walkenbach's enhanced dataform:
j-walk.com/ss/dataform/index.htm

Dexxterr wrote:
gt;
gt; Hi all. Trying to create a data input form in Excel, with over 40 fields.
gt; The built-in form on the data menu allows only 32 columns of data. Is it
gt; possible to create a bespoke form in Excel or Word to generate more than 32?

--

Dave Peterson

Dave - thank you for that. JW's 'features' describes this as having an
unlimited number of potential fields - which is what I was after. All I have
to do now is learn to use VBA...

Thanks again, regards,

D.

quot;Dave Petersonquot; wrote:

gt; You may want to look at John Walkenbach's enhanced dataform:
gt; j-walk.com/ss/dataform/index.htm
gt;
gt; Dexxterr wrote:
gt; gt;
gt; gt; Hi all. Trying to create a data input form in Excel, with over 40 fields.
gt; gt; The built-in form on the data menu allows only 32 columns of data. Is it
gt; gt; possible to create a bespoke form in Excel or Word to generate more than 32?
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Thank you Dave; that does the job fine. Now, how can I create something
similar?

D.

quot;Dave Petersonquot; wrote:

gt; You may want to look at John Walkenbach's enhanced dataform:
gt; j-walk.com/ss/dataform/index.htm
gt;
gt; Dexxterr wrote:
gt; gt;
gt; gt; Hi all. Trying to create a data input form in Excel, with over 40 fields.
gt; gt; The built-in form on the data menu allows only 32 columns of data. Is it
gt; gt; possible to create a bespoke form in Excel or Word to generate more than 32?
gt;
gt; --
gt;
gt; Dave Peterson
gt;

You can use his program as-is. Or you could even buy his code ($20USA, IIRC)
and modify it the way you want.
Dexxterr wrote:
gt;
gt; Thank you Dave; that does the job fine. Now, how can I create something
gt; similar?
gt;
gt; D.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; You may want to look at John Walkenbach's enhanced dataform:
gt; gt; j-walk.com/ss/dataform/index.htm
gt; gt;
gt; gt; Dexxterr wrote:
gt; gt; gt;
gt; gt; gt; Hi all. Trying to create a data input form in Excel, with over 40 fields.
gt; gt; gt; The built-in form on the data menu allows only 32 columns of data. Is it
gt; gt; gt; possible to create a bespoke form in Excel or Word to generate more than 32?
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Dave

Yes, I could - it's more a case of getting better with Excel. I have
started something in the VBE and am thoroughly enjoying myself!!! (Wierd, eh?)

Thanks again, most appreciated.

Regards,

D.quot;Dave Petersonquot; wrote:

gt; You can use his program as-is. Or you could even buy his code ($20USA, IIRC)
gt; and modify it the way you want.
gt;
gt;
gt;
gt; Dexxterr wrote:
gt; gt;
gt; gt; Thank you Dave; that does the job fine. Now, how can I create something
gt; gt; similar?
gt; gt;
gt; gt; D.
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; You may want to look at John Walkenbach's enhanced dataform:
gt; gt; gt; j-walk.com/ss/dataform/index.htm
gt; gt; gt;
gt; gt; gt; Dexxterr wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; Hi all. Trying to create a data input form in Excel, with over 40 fields.
gt; gt; gt; gt; The built-in form on the data menu allows only 32 columns of data. Is it
gt; gt; gt; gt; possible to create a bespoke form in Excel or Word to generate more than 32?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

You may want to buy a book. Debra Dalgleish has a list of books at her site:
www.contextures.com/xlbooks.html

John Walkenbach's is a nice one to start with.

Depending on how advanced you are...

Professional Excel Development
By Stephen Bullen, Rob Bovey, John Green

See if you can find them in your local bookstore/internet site and you can
choose what one you like best.
Dexxterr wrote:
gt;
gt; Dave
gt;
gt; Yes, I could - it's more a case of getting better with Excel. I have
gt; started something in the VBE and am thoroughly enjoying myself!!! (Wierd, eh?)
gt;
gt; Thanks again, most appreciated.
gt;
gt; Regards,
gt;
gt; D.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; You can use his program as-is. Or you could even buy his code ($20USA, IIRC)
gt; gt; and modify it the way you want.
gt; gt;
gt; gt;
gt; gt;
gt; gt; Dexxterr wrote:
gt; gt; gt;
gt; gt; gt; Thank you Dave; that does the job fine. Now, how can I create something
gt; gt; gt; similar?
gt; gt; gt;
gt; gt; gt; D.
gt; gt; gt;
gt; gt; gt; quot;Dave Petersonquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; You may want to look at John Walkenbach's enhanced dataform:
gt; gt; gt; gt; j-walk.com/ss/dataform/index.htm
gt; gt; gt; gt;
gt; gt; gt; gt; Dexxterr wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Hi all. Trying to create a data input form in Excel, with over 40 fields.
gt; gt; gt; gt; gt; The built-in form on the data menu allows only 32 columns of data. Is it
gt; gt; gt; gt; gt; possible to create a bespoke form in Excel or Word to generate more than 32?
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; Dave Peterson
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson