User Interface for Excel 2010

Hi Carl,

I'm using Excel 2007, not 2010. I'm just faintly understand your question. You can refer to my answer if it helps. This method is very simple and it doesn't care which Excel version you're using.
Currently (until Windows 7), you can open any text editor (e.g.: Notepad), type data into the file with comma (,) delimiter, save the file to *.csv. Please check out your tablet OS since I'm not a tablet's user.

Now, you go to Windows explorer (or something like that on tablet) and double click on the file to open it by Excel, you'll see data will be manipulate into cells.

Here is an example:
File name: "Test.csv"

File content:
Hello, world, I'm, a, new, Excel, user.

Hope it helps.  

Hey,

Sorry, obviously my explaiantion was poor.... I would like a very simply data entry form that a user can enter a value, then press enter have that data enter a spreadsheet, then clear the previous entry, and then be ready for a new entry which will be entered into the next row in the spreadsheet.

I imagine a program could be written to do this, but I was wonderingif there were any easier methods avaialble, like within excel.

Hope this adds some clarity to me request.

Kind Regards,

Carl

This is exactly what access is for. Just make a table in access, do the form wizard, and bingo you have a basic version of exactly what you want. You can add stuff later.

No real details on how to make user forms.