+ Reply to Thread
Results 1 to 4 of 4

Data entry with condiation

  1. #1
    Forum Contributor
    Join Date
    10-21-2012
    Location
    Ind
    MS-Off Ver
    Excel 2010
    Posts
    110

    Data entry with condiation

    Hi All,

    I need your help. In column “A” I have data. As shown below

    LOCKA

    LOCKB

    LOCKC

    LOCKD

    What I am trying to is, if column A contains LOCKA, LOCKB, LOCKC then only user can enter data into B column. As shown below

    Col – A Col – B

    LOCKA XXX

    LOCKB XXX

    LOCKC XXX


    If column A contains LOCKD & user trying to enter data then code should not accept the data & show msgbox that “Its LOCKD you can’t enter data”. I need to do this Via VBA.

    Col – A Col – B

    LOCKD Error MsgBox & Should not accept the data.

    Request you to please help with this.

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Data entry with condiation

    You can try Data Validation to achieve that.
    Assuming your data start from row 2, then
    Select the range B2:B? (say B2:B100), then click on Data-->Data Validation-->Allow-->Custom and then in the formula box type the below formula and now click on Error Alert Tab and in the error message box type the message you want to show and click OK.

    Please Login or Register  to view this content.
    Hope this helps.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor
    Join Date
    10-21-2012
    Location
    Ind
    MS-Off Ver
    Excel 2010
    Posts
    110

    Re: Data entry with condiation

    Hi sktneer, Thanks for your reply but its not working. Please find attached workbook.
    Attached Files Attached Files

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Data entry with condiation

    Please find the attached sheet to see if this works as per your requirement.
    Attached Files Attached Files

+ 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. Replies: 0
    Last Post: 02-04-2014, 12:36 AM
  2. how to entry same number twice when I alr set cannnot entry duplicate data.
    By Adamlearnexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2012, 09:44 PM
  3. Vba for move data & clear entry screen for entry new data..
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-27-2012, 09:19 PM
  4. Replies: 0
    Last Post: 10-06-2011, 07:03 AM
  5. How do I prevent data entry in one cell if an entry exist in another cell
    By rkjudy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-13-2010, 09:38 PM

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