How to create Excel Form in Excel 2003

T

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?
 
T

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?
 
T

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.
 
D

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?
Click to expand...
 
Top