How to create Excel Form in Excel 2003

Because of the limited fields for a Data Form, it appears that I have to
create an Excel form. I cannot find a source for how to do this. I've set up
the entry info on one tab, have the fields for the data on another tab. What
do I need to do to be able to move from record to record in the entry tab and
do other things similar to an Access form?
--
TDay

Dave
Sat Mar 15 11:08:52 CDT 2008

John Walkenbach has an enhanced data form:
http://j-walk.com/ss/dataform/index.htm

And the source code is available for a small fee ($20 USA, IIRC).

And if that's not sufficient, then maybe you could design your own input
userform.

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html

TDay wrote:
>
> Because of the limited fields for a Data Form, it appears that I have to
> create an Excel form. I cannot find a source for how to do this. I've set up
> the entry info on one tab, have the fields for the data on another tab. What
> do I need to do to be able to move from record to record in the entry tab and
> do other things similar to an Access form?
> --
> TDay

--

Dave Peterson

FSt1
Sat Mar 15 11:21:00 CDT 2008

hi
try these
http://www.bettersolutions.com/excel/EVZ193/LT423111411.htm
http://www.exceltip.com/st/Create_User_Forms_in_Microsoft_Excel/629.html
http://www.ozgrid.com/VBA/UserForms.htm
http://msdn2.microsoft.com/en-us/library/aa192538(office.11).aspx
http://www.msofficehelp.net/excel_vba/UserForms_InputBoxes/

and i doubt that you will get a excel form to act like a access form in the
way you are speaking of. excel is a different enviroment.

Regards
FSt1

"TDay" wrote:

> Because of the limited fields for a Data Form, it appears that I have to
> create an Excel form. I cannot find a source for how to do this. I've set up
> the entry info on one tab, have the fields for the data on another tab. What
> do I need to do to be able to move from record to record in the entry tab and
> do other things similar to an Access form?
> --
> TDay

TDay
Sun Mar 16 19:43:00 CDT 2008

The second site was helpful, but I am concerned about a comment on John's
page. What did he mean by "which is not even part of the user interface in
Excel 2007". Since I'm working in 2003, will I have problems with 2007?
--
TDay


"Dave Peterson" wrote:

> John Walkenbach has an enhanced data form:
> http://j-walk.com/ss/dataform/index.htm
>
> And the source code is available for a small fee ($20 USA, IIRC).
>
> And if that's not sufficient, then maybe you could design your own input
> userform.
>
> Debra Dalgleish shares some tips:
> http://contextures.com/xlUserForm01.html
>
> TDay wrote:
> >
> > Because of the limited fields for a Data Form, it appears that I have to
> > create an Excel form. I cannot find a source for how to do this. I've set up
> > the entry info on one tab, have the fields for the data on another tab. What
> > do I need to do to be able to move from record to record in the entry tab and
> > do other things similar to an Access form?
> > --
> > TDay
>
> --
>
> Dave Peterson
>

TDay
Sun Mar 16 19:50:00 CDT 2008

Very helpful, Thanks. From the posts, I think the form can use code to move
from record to record and probably I can code a find record also.
--
TDay


"FSt1" wrote:

> hi
> try these
> http://www.bettersolutions.com/excel/EVZ193/LT423111411.htm
> http://www.exceltip.com/st/Create_User_Forms_in_Microsoft_Excel/629.html
> http://www.ozgrid.com/VBA/UserForms.htm
> http://msdn2.microsoft.com/en-us/library/aa192538(office.11).aspx
> http://www.msofficehelp.net/excel_vba/UserForms_InputBoxes/
>
> and i doubt that you will get a excel form to act like a access form in the
> way you are speaking of. excel is a different enviroment.
>
> Regards
> FSt1
>
> "TDay" wrote:
>
> > Because of the limited fields for a Data Form, it appears that I have to
> > create an Excel form. I cannot find a source for how to do this. I've set up
> > the entry info on one tab, have the fields for the data on another tab. What
> > do I need to do to be able to move from record to record in the entry tab and
> > do other things similar to an Access form?
> > --
> > TDay

Dave
Sun Mar 16 20:11:24 CDT 2008

Data|Form isn't built into the ribbon. But you can add it to the QAT (quick
access toolbar). The QAT is kind of the same thing as a toolbar in xl2003.

I don't think you'd have trouble using John's enhanced data form.

Here are a couple more links:

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en-us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp
Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp

TDay wrote:
>
> The second site was helpful, but I am concerned about a comment on John's
> page. What did he mean by "which is not even part of the user interface in
> Excel 2007". Since I'm working in 2003, will I have problems with 2007?
> --
> TDay
>
> "Dave Peterson" wrote:
>
> > John Walkenbach has an enhanced data form:
> > http://j-walk.com/ss/dataform/index.htm
> >
> > And the source code is available for a small fee ($20 USA, IIRC).
> >
> > And if that's not sufficient, then maybe you could design your own input
> > userform.
> >
> > Debra Dalgleish shares some tips:
> > http://contextures.com/xlUserForm01.html
> >
> > TDay wrote:
> > >
> > > Because of the limited fields for a Data Form, it appears that I have to
> > > create an Excel form. I cannot find a source for how to do this. I've set up
> > > the entry info on one tab, have the fields for the data on another tab. What
> > > do I need to do to be able to move from record to record in the entry tab and
> > > do other things similar to an Access form?
> > > --
> > > TDay
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson