+ Reply to Thread
Results 1 to 5 of 5

Undele Button Macro

  1. #1
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,813

    Undele Button Macro

    Hello,

    I need a macro that if I accidentally delete an item in cell that I can click the button and bring back the undelete items. Sometimes I accidentally deleted an item in a cell and I don't which Item and i permanently lost it.

    My entry are from A6:D Sheet1

    Thanks.

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,723

    Re: Undele Button Macro

    Use Ctrl+Z for windows and Command+Z for Apple
    The inherent weakness of the liberal society: a too rosy view of humanity.

  3. #3
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,813

    Re: Undele Button Macro

    there is no macro button for this?

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,485

    Re: Undele Button Macro

    What's wrong with the undo / redo arrows in the title bar of the app?

    This VBA will undo very last action.

    Please Login or Register  to view this content.
    But just using VBA will destroy the undo stack, so only last action can be undone.
    More details here
    https://jkp-ads.com/articles/undowithvba00.asp
    Cheers
    Andy
    www.andypope.info

  5. #5
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,813

    Re: Undele Button Macro

    Hello

    Ok. This is what I got so far. The problem is that it only bring the last deleted entry. Is it possible to do at least the last 3 or 4 deleted entry?

    Thanks in advance!

    Please Login or Register  to view this content.

+ 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] Have spin button call macro repeatedly when mouse button is held down
    By czlowiek121 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-10-2019, 12:44 PM
  2. [SOLVED] Copy table column "and" macro button over to right with each push of macro button
    By xlyfe in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2018, 04:24 PM
  3. Automatically add button when data added to cell and apply macro to button?
    By dori2o in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-14-2016, 11:56 AM
  4. [SOLVED] Macro button copies sheet containing a macro button as an image
    By namso1902 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2013, 03:51 PM
  5. Modifying a Macro Button to time stamp when the button was clicked.
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-22-2010, 04:46 PM
  6. A macro to create a form button, assign a macro and name the button
    By cl361 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2008, 01:07 AM

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