It is possible to have a front end of some kind on a spreadsheet in the same
way I can use a Form in Access to allow a user to enter data without doing so
directly into the grid?

Yoda
Type: "Add, edit, find, and delete rows by using a data form" into Excel Help
I think this is what you're looking for ?

"Yoda" wrote:

It is possible to have a front end of some kind on a spreadsheet in the same
way I can use a Form in Access to allow a user to enter data without doing so
directly into the grid?

I don't speak the Access, but you may want to look at Data|Form (in xl2003
menus). If you're using xl2007, I think you have to add it to the QAT (or run a
macro).

If that's not enough...
You could look at John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm

The source code is available for a small fee ($20 USA, IIRC). So you can modify
it as much as you want.

=========

Or you could build your own...

Debra Dalgleish has some nice notes about userforms:
http://contextures.com/xlUserForm01.html
(video: http://contextures.com/xlVideos05.html#UserForm01)
and
http://contextures.com/xlUserForm02.html


Yoda wrote:

It is possible to have a front end of some kind on a spreadsheet in the same
way I can use a Form in Access to allow a user to enter data without doing so
directly into the grid?

--

Dave Peterson