+ Reply to Thread
Results 1 to 6 of 6

VBA: Restricting cell entry with condition

  1. #1
    Registered User
    Join Date
    10-29-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2016
    Posts
    24

    VBA: Restricting cell entry with condition

    Hi,

    Am looking for a formula to restrict the entries cells...e.g., can be entered in B10 only after entry in A10 and can be entered in C10 only after entry in B10..etc.,

    But this has two issues:

    1. After entry in A2 and B2, if A2 is cleared (deleted) B2 should become null

    2. Should not allow to paste directly in those cells

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Restricting cell entry with condition

    Quote Originally Posted by rajasekhargvd View Post
    Am looking for a formula to restrict
    Using VBA it's possible

    Please confirm whether we can arrive this using VBA?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    10-29-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2016
    Posts
    24

    Re: Restricting cell entry with condition

    Please...advice

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,421

    Re: VBA: Restricting cell entry with condition

    Moved to VBA section.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Registered User
    Join Date
    10-29-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2016
    Posts
    24

    Re: Restricting cell entry with condition

    Awaiting you reply

  6. #6
    Registered User
    Join Date
    10-29-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2016
    Posts
    24

    Re: Restricting cell entry with condition

    Can Anybody help me ...…………….

+ 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. [SOLVED] Restricting Entry In Text Box
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 12-22-2014, 06:38 AM
  2. Restricting entry in a cell based on value in another cell
    By Bachi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-18-2013, 12:16 PM
  3. Restricting entry into multiple cells
    By maryfay in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-04-2012, 07:10 AM
  4. Restricting cell entry in a Shared Workbook when a user updating a cell
    By Starbucks Junkie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-02-2009, 09:22 AM
  5. [SOLVED] Restricting entry in B1 on the basis of entry in A1
    By Stilla in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-03-2005, 05:20 PM
  6. [SOLVED] Re: Restricting entry in B1 on the basis of entry in A1
    By Biff in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-02-2005, 11:45 PM
  7. [SOLVED] Restricting data entry
    By JT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2005, 04:05 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