Shortcut keys for merging cells in excel code#
Now, whenever anyone inserts a new worksheet, this code would automatically be executed and add the year prefix to the worksheet’s name.Īnother example could be that you want to change the color of the cell when someone double-clicks on it. So you only need to write the code and place it in the correct event subroutine (this is covered later in this article).įor example, if you insert a new worksheet and you want it to have a year prefix, you can write the code for it. This means that as soon as an event occurs, and if you have specified a code for that event, that code would instantly be executed.Įxcel automatically does this as soon as it notices that an event has taken place. There are many such events in VBA, and you can create codes for these events. When you double-click on a cell, it’s an event. When you insert a new worksheet, it’s an event. Let me first explain what is an event in VBA.Īn event is an action that can trigger the execution of the specified macro.įor example, when you open a new workbook, it’s an event.
➢ Excel provides several keyboard shortcuts or Excel shortcuts for many commonly used commands. In a word, keyboard shortcuts can help Excel users to manage big datasets faster and handle them more efficiently because users' hands remain on the keyboard. Here we explain all about ALT Shortcut Keys and their uses as well. WHAT IS THE MEANING OF EXCEL SHORTCUTS?Ī keyboard shortcut or Excel shortcut is a key or combination of keys, after using them allow Excel users to access a particular feature or perform a command in a very short time. TYPE 5: ADVANCED EXCEL SHORTCUTS WITH ‘ALT' KEY & ‘PUNCTUATION' KEYS TYPE 4: ADVANCED EXCEL SHORTCUTS WITH ‘ALT' KEY & ‘SPECIAL' KEYS TYPE 2: ADVANCED EXCEL SHORTCUTS WITH ‘ALT' KEY & ‘FUNCTION' KEYS TYPE 1: ADVANCED EXCEL SHORTCUTS WITH ‘ALT' KEY & ‘ALPHABET' KEYS
0 kommentar(er)
