ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Is it possible to extend the number of fields in an Excel form? (https://www.excelbanter.com/excel-worksheet-functions/454399-possible-extend-number-fields-excel-form.html)

Daddy Sage

Is it possible to extend the number of fields in an Excel form?
 
I have a spreadsheet with 37 columns. If I try to use the form function it only allows 32 fields in the form. Is it possible to extend this so alæl my 37 fields are included in the form.

GS[_6_]

Is it possible to extend the number of fields in an Excel form?
 
I have a spreadsheet with 37 columns. If I try to use the form function it
only allows 32 fields in the form. Is it possible to extend this so alæl my
37 fields are included in the form.


Have a look at John Walkenbach's Enhanced Data Form...

http://spreadsheetpage.com/index.php/dataform/home/

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Daddy Sage

Is it possible to extend the number of fields in an Excel form?
 
onsdag den 14. august 2019 kl. 17.07.45 UTC+2 skrev GS:
I have a spreadsheet with 37 columns. If I try to use the form function it
only allows 32 fields in the form. Is it possible to extend this so alæl my
37 fields are included in the form.


Have a look at John Walkenbach's Enhanced Data Form...

http://spreadsheetpage.com/index.php/dataform/home/

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Sorry, but the link doesn't seem to work. It just brings me to this:
Redirecting you to http://spreadsheetpage.com/index.php/dataform/home/

and then nothing more happens. spreadsheet.com doesn't seem to exist. I find it if I google it, but the link from Google doesn't work either.

Jan
Jan

GS[_6_]

Is it possible to extend the number of fields in an Excel form?
 
onsdag den 14. august 2019 kl. 17.07.45 UTC+2 skrev GS:
I have a spreadsheet with 37 columns. If I try to use the form function it
only allows 32 fields in the form. Is it possible to extend this so alæl my
37 fields are included in the form.


Have a look at John Walkenbach's Enhanced Data Form...

http://spreadsheetpage.com/index.php/dataform/home/

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Sorry, but the link doesn't seem to work. It just brings me to this:
Redirecting you to http://spreadsheetpage.com/index.php/dataform/home/

and then nothing more happens. spreadsheet.com doesn't seem to exist. I find
it if I google it, but the link from Google doesn't work either.

Jan
Jan


Hhmm! Maybe John has retired so I'll see if I have a copy archived somewhere.
If so I'll post a link...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Daddy Sage

Is it possible to extend the number of fields in an Excel form?
 
torsdag den 15. august 2019 kl. 21.52.46 UTC+2 skrev GS:
onsdag den 14. august 2019 kl. 17.07.45 UTC+2 skrev GS:
I have a spreadsheet with 37 columns. If I try to use the form function it
only allows 32 fields in the form. Is it possible to extend this so alæl my
37 fields are included in the form.

Have a look at John Walkenbach's Enhanced Data Form...

http://spreadsheetpage.com/index.php/dataform/home/

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Sorry, but the link doesn't seem to work. It just brings me to this:
Redirecting you to http://spreadsheetpage.com/index.php/dataform/home/

and then nothing more happens. spreadsheet.com doesn't seem to exist. I find
it if I google it, but the link from Google doesn't work either.

Jan
Jan


Hhmm! Maybe John has retired so I'll see if I have a copy archived somewhere.
If so I'll post a link...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Sorry for the delay. I 've been away fro my computer for some days. If you could post a link it would be great. Thank you.

Jan

GS[_6_]

Is it possible to extend the number of fields in an Excel form?
 
torsdag den 15. august 2019 kl. 21.52.46 UTC+2 skrev GS:
onsdag den 14. august 2019 kl. 17.07.45 UTC+2 skrev GS:
I have a spreadsheet with 37 columns. If I try to use the form function
it only allows 32 fields in the form. Is it possible to extend this so
alæl my 37 fields are included in the form.

Have a look at John Walkenbach's Enhanced Data Form...

http://spreadsheetpage.com/index.php/dataform/home/

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Sorry, but the link doesn't seem to work. It just brings me to this:
Redirecting you to http://spreadsheetpage.com/index.php/dataform/home/

and then nothing more happens. spreadsheet.com doesn't seem to exist. I
find it if I google it, but the link from Google doesn't work either.

Jan
Jan


Hhmm! Maybe John has retired so I'll see if I have a copy archived
somewhere. If so I'll post a link...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Sorry for the delay. I 've been away fro my computer for some days. If you
could post a link it would be great. Thank you.

Jan


Found it!

https://app.box.com/s/cy9rc6ndnmjjh0p7zotg5p15zsq5g51b

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Daddy Sage

Is it possible to extend the number of fields in an Excel form?
 
mandag den 19. august 2019 kl. 18.36.29 UTC+2 skrev GS:
torsdag den 15. august 2019 kl. 21.52.46 UTC+2 skrev GS:
onsdag den 14. august 2019 kl. 17.07.45 UTC+2 skrev GS:
I have a spreadsheet with 37 columns. If I try to use the form function
it only allows 32 fields in the form. Is it possible to extend this so
alæl my 37 fields are included in the form.

Have a look at John Walkenbach's Enhanced Data Form...

http://spreadsheetpage.com/index.php/dataform/home/

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Sorry, but the link doesn't seem to work. It just brings me to this:
Redirecting you to http://spreadsheetpage.com/index.php/dataform/home/

and then nothing more happens. spreadsheet.com doesn't seem to exist. I
find it if I google it, but the link from Google doesn't work either..

Jan
Jan

Hhmm! Maybe John has retired so I'll see if I have a copy archived
somewhere. If so I'll post a link...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Sorry for the delay. I 've been away fro my computer for some days. If you
could post a link it would be great. Thank you.

Jan


Found it!

https://app.box.com/s/cy9rc6ndnmjjh0p7zotg5p15zsq5g51b

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Sorry but the link only points to the instructions, not to the code. The J-walk.com homepage that is referred to and which I have used intensivly in the old days, is gone as well as spreadsheetpage.com, So I guess you are right and John Walkenbach has retiresd from the net.

Jan

GS[_6_]

Is it possible to extend the number of fields in an Excel form?
 
mandag den 19. august 2019 kl. 18.36.29 UTC+2 skrev GS:
torsdag den 15. august 2019 kl. 21.52.46 UTC+2 skrev GS:
onsdag den 14. august 2019 kl. 17.07.45 UTC+2 skrev GS:
I have a spreadsheet with 37 columns. If I try to use the form function
it only allows 32 fields in the form. Is it possible to extend this so
alæl my 37 fields are included in the form.

Have a look at John Walkenbach's Enhanced Data Form...

http://spreadsheetpage.com/index.php/dataform/home/

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Sorry, but the link doesn't seem to work. It just brings me to this:
Redirecting you to http://spreadsheetpage.com/index.php/dataform/home/

and then nothing more happens. spreadsheet.com doesn't seem to exist. I
find it if I google it, but the link from Google doesn't work either.

Jan
Jan

Hhmm! Maybe John has retired so I'll see if I have a copy archived
somewhere. If so I'll post a link...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Sorry for the delay. I 've been away fro my computer for some days. If you
could post a link it would be great. Thank you.

Jan


Found it!

https://app.box.com/s/cy9rc6ndnmjjh0p7zotg5p15zsq5g51b

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Sorry but the link only points to the instructions, not to the code. The
J-walk.com homepage that is referred to and which I have used intensivly in
the old days, is gone as well as spreadsheetpage.com, So I guess you are
right and John Walkenbach has retiresd from the net.

Jan


My link is to the original zip I got from J-Walk. Please try again...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

GS[_6_]

Is it possible to extend the number of fields in an Excel form?
 
Sorry but the link only points to the instructions

The file is dataform2.zip
Click the DOWNLOAD button when the page appears, then extract the zip!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

GS[_6_]

Is it possible to extend the number of fields in an Excel form?
 

Sorry but the link only points to the instructions, not to the code. The
J-walk.com homepage that is referred to and which I have used intensivly in
the old days, is gone as well as spreadsheetpage.com, So I guess you are
right and John Walkenbach has retiresd from the net.

Jan


Oops! Sorry.., my bad!

Look for Dataform2.zip (v2)
https://app.box.com/s/cy9rc6ndnmjjh0p7zotg5p15zsq5g51b

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Daddy Sage

Is it possible to extend the number of fields in an Excel form?
 
onsdag den 21. august 2019 kl. 17.47.44 UTC+2 skrev GS:

Sorry but the link only points to the instructions, not to the code. The
J-walk.com homepage that is referred to and which I have used intensivly in
the old days, is gone as well as spreadsheetpage.com, So I guess you are
right and John Walkenbach has retiresd from the net.

Jan


Oops! Sorry.., my bad!

Look for Dataform2.zip (v2)
https://app.box.com/s/cy9rc6ndnmjjh0p7zotg5p15zsq5g51b

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Thank you, Got it now.

Jan

Daddy Sage

Is it possible to extend the number of fields in an Excel form?
 
onsdag den 21. august 2019 kl. 17.47.44 UTC+2 skrev GS:

Sorry but the link only points to the instructions, not to the code. The
J-walk.com homepage that is referred to and which I have used intensivly in
the old days, is gone as well as spreadsheetpage.com, So I guess you are
right and John Walkenbach has retiresd from the net.

Jan


Oops! Sorry.., my bad!

Look for Dataform2.zip (v2)
https://app.box.com/s/cy9rc6ndnmjjh0p7zotg5p15zsq5g51b

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Do you happen to know the password for the code? When I try to use the one in the usermanual it just say's Invalid password.

GS[_6_]

Is it possible to extend the number of fields in an Excel form?
 
onsdag den 21. august 2019 kl. 17.47.44 UTC+2 skrev GS:

Sorry but the link only points to the instructions, not to the code. The
J-walk.com homepage that is referred to and which I have used intensivly in
the old days, is gone as well as spreadsheetpage.com, So I guess you are
right and John Walkenbach has retiresd from the net.

Jan


Oops! Sorry.., my bad!

Look for Dataform2.zip (v2)
https://app.box.com/s/cy9rc6ndnmjjh0p7zotg5p15zsq5g51b

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Do you happen to know the password for the code? When I try to use the one in
the usermanual it just say's Invalid password.


Sorry about that; - I changed it to a single space character! So when the
prompt pops up, just hit the spacebar, then the Enter key.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Daddy Sage

Is it possible to extend the number of fields in an Excel form?
 
lørdag den 24. august 2019 kl. 15.52.18 UTC+2 skrev GS:
onsdag den 21. august 2019 kl. 17.47.44 UTC+2 skrev GS:

Sorry but the link only points to the instructions, not to the code. The
J-walk.com homepage that is referred to and which I have used intensivly in
the old days, is gone as well as spreadsheetpage.com, So I guess you are
right and John Walkenbach has retiresd from the net.

Jan

Oops! Sorry.., my bad!

Look for Dataform2.zip (v2)
https://app.box.com/s/cy9rc6ndnmjjh0p7zotg5p15zsq5g51b

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Do you happen to know the password for the code? When I try to use the one in
the usermanual it just say's Invalid password.


Sorry about that; - I changed it to a single space character! So when the
prompt pops up, just hit the spacebar, then the Enter key.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Thank you. That di the trick.

Jan


All times are GMT +1. The time now is 03:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com