Therefore, I created a macro to add one month if a selected cell contains a date literal (not a formula), and I made the macro easy to run by giving it a keyboard shortcut (Ctrl+Shift+M). I noticed that several of the bills are received and/or due on the same day each month. I have a spreadsheet to keep track of monthly bills including date received and date due. We will also learn that programming the Repeat button is not recommended because it upsets the Redo button’s normal function. For these reasons, I normally remove the Redo button from my Quick Access toolbar, but let us keep Undo, Redo, and Repeat for now. As we will learn, there is no way to program the Redo button in VBA only the Undo and Repeat buttons offer that feature.
In fact the Repeat button frequently “becomes” the Redo button, including sharing its icon. Now before you ask, why do Redo and Repeat share the same keyboard shortcut (Ctrl+Y)? I wish I knew. In this tutorial, we’re going to incrementally develop a series of macros to demonstrate this behavior. But did you know you can program the behavior of the Undo and Repeat buttons using VBA? If done carefully, this lets you simulate undoing a macro after it was executed. You might subsequently notice the Repeat button (also Ctrl+Y) repeats the Excel macro that was recently run. You might have noticed the Undo (Ctrl+Z) and Redo (Ctrl+Y) buttons usually lose their previous “stack” of choices whenever you run an Excel macro. (The Back button can be ignored for the remainder.)
The screenshot includes my Custom ribbon, where I have duplicated these four buttons for better illustration of this discussion.
Here is a screenshot of my Quick Access toolbar, where I have added the Back button to the left of Undo and the Repeat button to the right of Redo. If you have not modified Excel’s Quick Access toolbar, it probably includes the Undo and Redo buttons.
0 kommentar(er)
