How to create Excel Form in Excel 2003

[TDay]

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?

 

[Dave Peterson]

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

 

[FSt1]

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]

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]

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.

 

[Dave Peterson]

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

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?