+ Reply to Thread
Results 1 to 1 of 1

Force user to delete content of cell

  1. #1
    Registered User
    Join Date
    03-12-2022
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    94

    Force user to delete content of cell

    Is there a way to force users to delete content of cells first before making changes to data in that cell?

    To make changes, users can not just type over old data but instead they should have to delete content first and then enter new data......

    I am trying to achieve this without VBA


    I have a workbook in Microsoft SharePoint that requires timestamping. Unfortunately VBA does not work on their on-line version of excel. Therefore I need a formula to run a timestamp whenever a user changes a value in a cell. The formula I found only works if user clears out cell first but not if they just type over old data.
    Last edited by davesexcel; 04-25-2024 at 05:41 AM.

+ 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. Is there a VBA Macro Function to Force Delete A Row Based on a Blank Cell to The Right?
    By ExcelMatthew7 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2020, 12:12 PM
  2. [SOLVED] Force data entry in cell with drop down list (i.e. Prevent user from leaving cell blank)
    By moosetales in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2014, 05:28 AM
  3. IF same CONTENT FOUND IN CELL A THEN DELETE CONTENT IN B,C or D
    By mecutemecute in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-11-2013, 01:16 AM
  4. Force a user to carry out a task after entry into a specific cell
    By wileydogdan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-27-2012, 12:40 PM
  5. Replies: 1
    Last Post: 06-15-2011, 02:36 AM
  6. How can I force a user to fill a certain cell
    By fanny.may in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-23-2011, 07:10 AM
  7. force a user to fill a certain cell
    By fanny.may in forum Excel General
    Replies: 3
    Last Post: 03-22-2011, 09:35 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