This shortcut also opens the same VB Editor. Or you can use the keyboard shortcut – ALT + F11 (hold the ALT key and press F11), instead of the above two steps. In the Code group, click the Visual Basic button. Here are the steps to open the VB Editor in Excel: Now let’s go to the Excel backend – the VB Editor – and see what recording a macro really does. What Recording a Macro does in the Backend This is the same keyboard shortcut that we assigned to the macro when recording it. Note: You can also run the macro using the keyboard shortcut Control + Shift + N (hold the Control and the Shift keys and then press the N key). So the macro first selects the cell A2, then enters the text Excel in it, and then selects the cell A3. Now, this may all happen in a split second, but in reality, the macro – just like an obedient elf – followed the exact steps you showed it while recording the macro. You will notice that as soon as you click the Run button, the text ‘Excel’ gets inserted into cell A2 and cell A3 gets selected.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |