+ Reply to Thread
Results 1 to 4 of 4

Is it possible to restrict user to input certain data without refering to another cell?

  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Is it possible to restrict user to input certain data without refering to another cell?

    I want to restrict user from entering alphabets like I,O,Q and S in a cell. Can we do this using data validation or any formula because I don't wan't to use drop-down list or refer to values in other cells either.

  2. #2
    Registered User
    Join Date
    11-20-2013
    Location
    Las Vegas, NV
    MS-Off Ver
    Excel 2010
    Posts
    64

    Re: Is it possible to restrict user to input certain data without refering to another cell

    If you want numbers only, how about you do data validation. Then select whole number and use the criteria "Greater Than or Equal to" and select 0.

  3. #3
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Is it possible to restrict user to input certain data without refering to another cell

    welcome to the forum. is it case sensitive? like if it's
    q
    is it accepted?

    is 1 single letter not allowed or none of those letters can be found? eg
    abQc
    is it accepted?

    select the cells you want the dropdown applied to (say A1:B5). go to Data -> Data Validation -> Allow: Custom-> Formula:
    non-case sensitive & none of the letters can be found:
    =COUNTIF(A1,"*I*")+COUNTIF(A1,"*O*")+COUNTIF(A1,"*Q")+COUNTIF(A1,"*S*")=0

    none-case sensitive & single letter:
    =AND(A1<>"I",A1<>"O",A1<>"Q",A1<>"S")

    case-sensitive & none of the letters can be found
    =AND(ISERR(FIND("I",A1)),ISERR(FIND("O",A1)),ISERR(FIND("Q",A1)),ISERR(FIND("S",A1)))

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  4. #4
    Registered User
    Join Date
    11-27-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Is it possible to restrict user to input certain data without refering to another cell

    Thank you benishiryo for the welcome and also for the prompt solution. Its exactly what I wanted and works fine for me. Sorry for providing less information, yes its only single letter and non-case sensitive

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vba excel user form restrict input on user textbox
    By samz93 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2013, 04:38 PM
  2. [SOLVED] Restrict user input to fraction and decimal only.
    By Garren1013 in forum Excel General
    Replies: 1
    Last Post: 12-26-2012, 01:32 PM
  3. Data Validation,Restrict Cell Input.
    By JapanDave in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-28-2011, 12:56 AM
  4. Restrict-Filter-Limit-Validate user input in Excel
    By Dr. Thom in forum Excel General
    Replies: 0
    Last Post: 01-22-2006, 04:10 PM
  5. Replies: 2
    Last Post: 01-25-2005, 04:06 AM

Tags for this Thread

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