Hi StargateFan,

Try Excels's dataform ( Menu | Data Form).

Alternatively, try John Walkenbach's Enhanced DataForm at:

J-Walk Enhanced Data Form v2
http://j-walk.com/ss/dataform/


---
Regards,
Norman
Microsoft Excel MVP



"StargateFan" wrote in message
...
I've never seen this so don't know if it's even possible -- can one do
something in Excel that approaches a database form?

In other words, can .an ordinary spreadsheet be enhanced with a user
input box that pops up with places where user types in pertinent data.
Then by pressing perhaps an "add new record" button on that form, the
data then gets dumped into the spreadsheet and the form is cleared
ready for a new "record".

Can this be done? I'm guessing it might be rather complicated, but
just curious.