User Interface for Excel 2010

Posted on 2011-05-10
Last Modified: 2012-05-11
Hi Experts,

I need a simple user interface for Excel, we have a tablet computer that is used for data entry of readings that get taken. The users are not tech savvy and have difficulty with entering data into the cells.

We need a data entry window that allows the data to be entered into a form that then populates the spreadsheet and then clears and gets ready for the next one....

Poor discription I know.... Does anyone have any ideas how to best achieve this..

Kind Regards,

Question by:carlnys
    LVL 1

    Expert Comment

    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.  

    Author Comment


    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,

    LVL 38

    Expert Comment

    by:Aaron Tomosky
    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.
    LVL 85

    Accepted Solution

    Excel has a built in data form or you could create your own userform and set it up as you wish. Hard to be more specific with the info provided.

    Author Closing Comment

    No real details on how to make user forms.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now