+ Reply to Thread
Results 1 to 3 of 3

Limit user entry

  1. 03-02-2012, 10:42 AM #1
    benjamin140
    benjamin140 is offline
    Registered User
    Join Date
    08-26-2011
    Location
    maine
    MS-Off Ver
    Excel 2007
    Posts
    6

    Limit user entry

    How could I limit user entry in a cell?

    Example:

    Only entries possible are:
    P
    PW
    L
    LM
    LE
    M
    ME
    E

    But not able to enter:
    PL
    PM
    PE

    TIA
    Reply With QuoteRegister To Reply
  2. 03-02-2012, 10:44 AM #2
    darknation144
    darknation144 is offline
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: Limit user entry

    Go to Data Tab > Data validation > Allow list > and enter your list or point excel to the list on a sheet.
    Last edited by darknation144; 03-02-2012 at 10:47 AM.
    Reply With QuoteRegister To Reply
  3. 03-02-2012, 11:16 AM #3
    benjamin140
    benjamin140 is offline
    Registered User
    Join Date
    08-26-2011
    Location
    maine
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Limit user entry

    Perfect. Thank you!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1