undo

I am currently using the following code to change a cell's color when the value in that cell changes, Private Sub Worksheet_Change(ByVal Target As Range) Target.Interior.ColorIndex = 6 End Sub However, I want to be able to use the "UNDO" button to change the value back and clear the cell...

Has anyone else noticed that Undo is not an option if you have multiple windows of the same workbook open? Is there a way around this? I enjoy having two windows open when working with multiple monitors instead of toggling between worksheets.

Whenever I test a macro, (with what is normally a non-successful result) I cannot Undo the operation by clicking the Undo arrow to go back, I have to close the file and start over with a fresh copy. Hugely annoying...Anyone know why?

Hey everyone! I have created an excel in which I insert blood exam results. I insert every patient manually. What I want to do is to assign a key (for example F5) to undo all changes made to the sheet at once. I know I can do it using undo button, but I'd like to have a specific key for that.

Hi If I delete plotted area grid lines in excel chat, is there anyway to get them back (not to use undo)? Thank you.

Hello All, Can anyone please modify the undo vba code in this sheet. It's not working properly. The undo button will place back the last entry that I made after I accidentally press the clear entry. Please check this file. https://www.dropbox.com/s/tzg14p356lu8wfy/undobutton.xlsm?dl=0 thank...

Hi There In one of my worksheets, the undo function has stopped working, it has been suggested that the problem I am having is due to the VB applied to this worksheet: Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) 'Update 20140318 Static xRow Static xColumn If xColumn <> ""...

Is there method to undo sort...........because if you apply sort function all cells are shifted according to sort function applied, but how can we undo this sort as the arrangement of cells remain the same after sort function.

Hi, If the user makes a certain change, I have a worksheet level macro that makes some formatting changes. The macro works well. Unfortunately, whenever it runs, the user loses the ability to Undo. Is there either: i) a way to keep the macro, but preserve the ability to undo, or ii)...

Hi I know the Undo stack is cleared when running a macro. I'm trying to maintain in one column the current date of when a cell in another column is changed. The code in the specific Sheet is: Private Sub Worksheet_Change(ByVal Target As Range) If Not (Intersect(Target...

Hi There: I inserted and Active X control (checkbox) and want it hidden if a certain cell (V1) = FALSE. I have the following code I have entered: Private Sub worksheet_calculate() EnterMonthlyBox1.Visible = Not Range("v1").Value End Sub Problem is when I do this the UNDO function is...

Hii, i want to know how to create and undo addin which will undo the actions performed by any other addin plss help...:):)

I am completely new to VBA and have learned quite a bit in the last week by working slowly on a personal project of mine. I have most of the essentials set up, but it is imperative that I provide the user the ability to undo a data submission when using a User Form. My submission code is as...

I am a total rookie and trying to solve an issue on a spreadsheet we use. The initial issue was when I had the column locked the sorting wasn't working properly. I tried a few methods that I found and had the best result by forcing anything entered into the column to be undone. The column has a...

I have a reoccurring problem; excel suddenly and in an uncontrolled fashion reverts a spreadsheet to a point where I was several minutes or hours ago. It seems to happen when I am do a copy/paste. Sometimes when I do a copy/paste the sheet suddenly “flashes” and I am back to where I was at...

I'm a VBA newbie, but managed to implement (aka copy) a macro that adds a time/date stamp in Column A when any of the subsequent cells in that row are changed. With this now working, I really need the ability to restore the undo history in case a change to the data needs to be reverted...

Hi guys! Here's another error that bothers me lately.The code is: If Not Intersect(Target, Range("B16:E28")) Is Nothing Then If Len(Target.Value) = False Then 'Or IsNumeric(Target) <> True Then Target.Value = "" With Application .EnableEvents = False...

Hi, I'm almost there to solve the loss of undo/redo-stack and clipboard by VBA made changes. I can already find out if the last keypress was undo or redo: If GetKeyState(vbKeyY) And -128 And GetKeyState(vbKeyControl) And -128 Then ' "Ctrl-Y" has been pressed If GetKeyState(vbKeyZ) And...

Hi all, I'm new to VBA & would like to use the MsgBox() function to display some of the data found in the information pop-up window when a user hovers the mouse over the undo button (e.g. Typing '=ABS(C3)' in C6). I want to take this text to put it into something like this: MsgBox("You just "...

I have a form control button I am trying to use to delete a range of cells and refill, but I do not want the formula references to shift if I add rows/columns. I am aware of naming the range but I cannot think of an appropriate way to apply that fix in this scenario. Ideally I would like to do...