+ Reply to Thread
Results 1 to 2 of 2

Error box Data Validation When Deleting/pasting

  1. #1
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Error box Data Validation When Deleting/pasting

    Is it possible to add an error box in Data Validation when a Cell is being edited? I managed to do so but it wont pop up when im deleting the value or copy paste, it wont show up, It just shows up when I type in a cell and change it. Is this also possible ? In the attached file I applied to this all the columns (A:M) but I can still delete it or copy paste it. How do I make this error box? Thanks.

    Errorbox.xlsx

  2. #2
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Re: Error box Data Validation When Deleting/pasting

    I know its possible but then I need to make it a read only document, I just want an errorbox when someone deletes a cell or pastes it

+ 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] Deleting Excess Rows in a Table When Pasting Data
    By snapfade in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-09-2013, 05:37 PM
  2. Data Validation and Pasting
    By Jim28 in forum Excel General
    Replies: 5
    Last Post: 06-23-2011, 11:31 PM
  3. Error when copying and pasting fields with validation
    By kristina in forum Excel General
    Replies: 12
    Last Post: 02-26-2009, 11:32 AM
  4. Pasting Without Deleting Previous Data
    By Onesimus in forum Excel General
    Replies: 4
    Last Post: 12-24-2007, 08:46 AM
  5. Macro for pasting, deleting, and shifting data
    By reel004 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2007, 06:33 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