+ Reply to Thread
Results 1 to 6 of 6

[SOLVED] How to enter single char data into Excel worksheet without hitting Enter

  1. #1
    Registered User
    Join Date
    02-21-2006
    Posts
    27

    [SOLVED] How to enter single char data into Excel worksheet without hitting Enter

    Hi

    I am looking for a way to enable fast data entry whereby a single character (between 0 and 9) is entered into a cell and the cursor then moves to the adjacent cell without having to hit Enter or Tab. I looked at Data Forms but those require a tab to move to the next field. I tried Worksheet Change Event but it still requires me to hit Enter after typing in the single character into the current cell to get to the adjacent cell.

    Each record has about 30 cells line up horizontally and each cell contains a single character between 0 and 9. There are a thousand records in one worksheet that require similar data entry hence having the capability I just described will make life a lot easier for the data entry folks.

    Any help or suggestion is much appreciated.

    Phil
    Last edited by vbarookie; 12-06-2010 at 04:58 PM.

  2. #2
    Registered User
    Join Date
    12-06-2010
    Location
    Washington, D.C.
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: How to enter single char data into Excel worksheet without hitting Enter or Tab k

    Maybe set up some type of macro ?

  3. #3
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: How to enter single char data into Excel worksheet without hitting Enter or Tab k

    To do this you would possibly be best to use the Worksheet Change Event and data validation

    Right click on the sheet tab and select > View code and paste all of this code in the resultant window.

    Please Login or Register  to view this content.

    Then Select your range to validate in this example A2:A75

    Data validation > List

    Source 1,2,3,4,5,6,7,8,9

    Try the demo workbook select from the drop-down in column A

    Hope this helps
    Attached Files Attached Files
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,669

    Re: How to enter single char data into Excel worksheet without hitting Enter or Tab k

    Here's another way.

    In the Sheet module:
    Please Login or Register  to view this content.
    In a code module:
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    02-21-2006
    Posts
    27

    Re: How to enter single char data into Excel worksheet without hitting Enter or Tab k

    Thanks Marcol. Your method works. I need to find out if the data entry folks are comfortable entering data via a drop down list.

  6. #6
    Registered User
    Join Date
    02-21-2006
    Posts
    27

    Re: How to enter single char data into Excel worksheet without hitting Enter or Tab k

    shg,

    Your method works. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1