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

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

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

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...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.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

hi
try these
http://www.bettersolutions.com/excel...T423111411.htm
http://www.exceltip.com/st/Create_Us...Excel/629.html
http://www.ozgrid.com/VBA/UserForms.htm
http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx
http://www.msofficehelp.net/excel_vb...ms_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

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...T423111411.htm
http://www.exceltip.com/st/Create_Us...Excel/629.html
http://www.ozgrid.com/VBA/UserForms.htm
http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx
http://www.msofficehelp.net/excel_vb...ms_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