How to Write a macro by hand in Excel for beginners

The speaker in this video introduces the concept of macros used in Excel, very simply and lucidly. Two sets of shortcut keys are used, one set to create the macro and the other set to run it. The first shortcut opens up the VBA window (Alt+F11), with a workbook along with the 3 default sheets. This video puts the macro in a module. The procedure starts with typing sub and a name which can be easily recalled. The rules for naming the macro are also covered briefly. After the macro code is written, which has been kept very simple, the macro is recalled from Excel by using Alt+F8 keys and the name of the macro. Very easy to do!

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest